(antoher) extract item from array question

How To
1

Hi there,
I read a few tutorials and thread here. I have done that in other make scenario. But can’t get this one workgin.
Here is the data structure (json) I simplified it.
[
{
“node”: {
“id”: “order_hbCzmpxLwNeJIQKCjWmdP”,

        "payments": [
            {
                "id": "pay_Wh13oi8Av6VExEvdd4b5-",
                "_id": 2247331,
                "total": 64.4,
                "source": {
                    "payment_gateway": {
                        "prototype": {
                            "key": "paypal"
                        }
                    }
                },
                "refunds": [],
                "refunded": 0,
                "sub_total": 64.4,
                "created_at": "a few seconds ago",
                "refundable": 64.4,
                "discount_snapshot": null,
                "price_bundle_snapshot": []
            }
        ],

image
image803×496 53.1 KB

I want to set a variable with the payments.source.payment_gateway.prototype.key
Here for example I should get the value “paypal”.
I used this formula in a set variable module

image
image860×501 45.6 KB

But the variable comes back empty.
Any Idear
Thanks

2

Welcome to the Make community!

I think you are confusing map with get.

  1. Change your get( to map(

  2. Then wrap it with first() or a get()

Links

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

Help Center Basics

2 Likes
3

Thanks a lot samliew,
Indeed it was a bit mixt up. I ended up trying lots of things and the screen shot I sent was definitively not the best ;). I did some more testing after reading tutos. I am still not successfull.
Any help would be appreciated
Regards

I tried this :

image
image817×585 46.3 KB

It gave this result (empty)

image
image880×525 42.1 KB

And here is the structure of the array I am trying to work with What I want is the the value of the source.payment_gateway.prototype.key. In this case “paypal”

image
image723×877 70.9 KB

4

Hi @anton_pre

This is a bit tricky. Please use the ‘get an toArray’ function as shown below.
Input:

image
image1088×465 69.3 KB

Output:
image
image1060×444 64.2 KB

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

3 Likes
5

Thanks a lot.
It worked.
That made my day :grinning:

2 Likes
6

@anton_pre

Glad to help you!

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes