Create a list of new things from API connector response

Need help Database
1

Hello !

I am currently working with Allmyles API that send this kind of response :

{
  "car_results": [
    {
      "available": true,
      "traits": {
        "transmission": "manual",
        "air_conditioning": true,
        "type": "2/4 door car",
        "class": "mini"
      },
      "vehicle_id": "1_0_0",
      "vendor_name": "NATIONAL",
      "overage_fee": {
        "currency": "EUR",
        "amount": null,
        "unit": null,
        "included_distance": null
      },
      "price": {
        "currency": "EUR",
        "amount": "75.48"
      },
      "vendor_id": "0",
      "unlimited": true,
      "vendor_code": "ZL"
    },
    {
      "available": true,
      "traits": {
        "transmission": "manual",
        "air_conditioning": true,
        "type": "4-5 door car",
        "class": "compact"
      },
      "vehicle_id": "2_1_0",
      "vendor_name": "EUROPCAR",
      "overage_fee": {
        "currency": "EUR",
        "amount": "0.14",
        "unit": "Mile",
        "included_distance": 300
      },
      "price": {
        "currency": "EUR",
        "amount": "98.90"
      },
      "vendor_id": "1",
      "unlimited": false,
      "vendor_code": "EP"
    }
  ]
}

I would like create a list of new thing via workflow, but here is what i am getting :

problem
problem1524×166 9.71 KB

How can i fix it ?

2

Disclaimer: I’m new and not a dev so this may not be the best answer but I did run into something similar with a football API.

In the Workflow, I had to set the API plugin, then create a step for each game; in your case, I think it’d be car, then set each piece of data I wanted from the API for each one. Kinda sucked.

The API I’m using identifies each individually, so I would say, Result of “API”'s home_team…then tell it which table and field to put it in. I don’t see that with the car api though so this be more difficult.

Screen Shot 2020-10-21 at 8.48.07 PM
Screen Shot 2020-10-21 at 8.48.07 PM1112×966 86.8 KB

3

Thanks for your answer, so i am trying to use backend workflows (i guess it’s what you meant by “I had to set the API plugin”) but here is what i get in alert box when i want try it :

“The Schedule API Event action requires access to the API and the scheduler. Please upgrade your plan to run this action.”

Does it mean that workflows backend is a paid functionality ?

4

Yeah, and the next level up only gives you one/month, I think