Create thing from API JSON

Need help APIs
1

I’m trying to create thing in database based on API response from a public service.
In response I got this code:

{
    "result": {
        "field_names": [
            "email",
            "phone",
            "Name",
            "email_add_time"
        ],
        "data": [
            [
                "testuseremail1@gmail.com",
                "89036984291",
                "Test User 1",
                "2018-04-06 06:55:36"
            ],
            [
                "testuseremail2@gmail.com",
                "9028838691",
                "Test User 2",
                "2018-04-06 07:02:27"
            ],
            [
                "testuseremail3@gmail.com",
                "795301424-5",
                "Test User 3",
                "2018-04-06 07:02:59"
            ]
        ]
    }
}

The number of object is not defined so there could be one, none or 100.
I’m struggling to add those values in Workflow - Create a thing
I tried to Body parameters as a variable but not sure this is a right place

image
image721×642 26.7 KB

Could you please help me?

2

I am guessing the answer is by creating a workflow.

When: button is clicked (for example)
Step 1.: [your plugin call - the one that you pasted above]
Step 2: Schedule API Workflow on a list

image
image673×519 42.5 KB

What do you think? Would this be the way?

1 Like
3

Thank you.
Your correct.
After spending couple of hours I was able to split entire API response in to variables (key) and then work with them to create things.