Question

The bounty expires in 7 days. Answers to this question are eligible for a +50 reputation bounty. AAA wants to draw more attention to this question:

Answer must work with N8N and jmespath,,,

在下文的JSON中,当价格为rpp=真实时,我试图选择原材料价值。这有时可能是第一种价格,也可能是所列价格的任何N数,但大部分时间是无价格或无价=真实价格。

这是可能的吗?

例如,使用{[“价格”][“价值”] 确实选择了我的价格,但我希望是_rpp=真实价格。

谢谢。

{
    "position": 1,
    "title": "Apple USB-C to Lightning Cable (2 m)",
    "asin": "asintest",
    "link": "https://www.amazon.com/",
    "categories": [{
        "name": "Electronics",
        "id": "electronics"
    }],
    "image": "https://m.media-amazon.com/images/",
    "is_prime": true,
    "rating": 4.8,
    "ratings_total": 15213956,
    "prices": [{
            "symbol": "$",
            "value": 29,
            "currency": "USD",
            "raw": "$29.00",
            "name": "$29.00",
            "is_primary": true
        },
        {
            "symbol": "$",
            "value": 35,
            "currency": "USD",
            "raw": "$35.00",
            "name": "$29.00",
            "is_rrp": true
        }
    ],
    "price": {
        "symbol": "$",
        "value": 29,
        "currency": "USD",
        "raw": "$29.00",
        "name": "$29.00",
        "is_primary": true
    },
    "page": "1",
    "position_overall": 1
}

将在N8N:https://docs.n8n.io/code-examples/expressions/jmespath/#an-alternative-to-arrow-Functions。

Answer 1

https://developer.mozilla.org

如果返回<代码>unfin,则意思是,在<代码>prices/code>阵列内未出现任何项目is_rpp=真实。

$json.prices?.find(p => p.is_rrp)?.value

const $json = {
    "position": 1,
    "title": "Apple USB-C to Lightning Cable (2 m)",
    "asin": "asintest",
    "link": "https://www.amazon.com/",
    "categories": [{
        "name": "Electronics",
        "id": "electronics"
    }],
    "image": "https://m.media-amazon.com/images/",
    "is_prime": true,
    "rating": 4.8,
    "ratings_total": 15213956,
    "prices": [{
            "symbol": "$",
            "value": 29,
            "currency": "USD",
            "raw": "$29.00",
            "name": "$29.00",
            "is_primary": true
        },
        {
            "symbol": "$",
            "value": 35,
            "currency": "USD",
            "raw": "$35.00",
            "name": "$29.00",
            "is_rrp": true
        }
    ],
    "price": {
        "symbol": "$",
        "value": 29,
        "currency": "USD",
        "raw": "$29.00",
        "name": "$29.00",
        "is_primary": true
    },
    "page": "1",
    "position_overall": 1
};

const rrpPrice = $json.prices?.find(p => p.is_rrp)?.value;

console.log(rrpPrice);  // 35

Answer 2

{{ $json.prices[?(@.is_rrp == true)].raw }}

当prices上>时,这将给你以原始价格价值。

注:根据具体执行情况,初等动物的表述可能有所不同。

友情链接