Creating Loop to update multiple records from an external API.

Lachlan McPherson

Hi Team,

I'm trying to populate my database from an external API. Currently I have data coming in from an external API, and I'm able to update my database for a single database item. However I cannot get it to loop to create all the items within the response as items in the database. 

I've got it creating a variable which im then saving in the database, but the problem is that I'm creating a variable with the value "0" which is returning the first result. I need to have this loop so that it returns all of the results. Everything I try is failing unfortunately 🤣 Screenshot: https://i.imgur.com/fsHxKfw.png

Any tips or advice would be greatly appreciated. 

Michael Udinski

I would check out this tutorial:



I would omit including the index if you are trying to add all the records from your external API and just loop through all of them. You shouldn't need a variable per field as well. 

Lachlan McPherson

Hi Michael,

Thank you very much for your response, I've followed the video and have been able to create multiple records. The issue I have is still how to have it push the correct record in, without me defining what the record number is within the array.


The response I'm getting from my created variable
[{"id":"115470___260225","pms":"beds24","name":"Bayside at Falcon Bay -- Bayside at Falcon Bay","min":100,"base":120,"max":null,"push_enabled":true,"health_7_day":"42.86","health_30_day":"86.67","health_60_day":"75.0","last_date_pushed":"2021-08-24T07:10:15.000Z"},{"id":"115472___260227","pms":"beds24","name":"Beach Cottage In The Heart Of Mandurah -- Beach Cottage In The Heart Of Mandurah","min":150,"base":200,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"76.67","health_60_day":"58.33","last_date_pushed":"2021-08-24T07:10:23.000Z"},{"id":"115473___260228","pms":"beds24","name":"Beachside At Silver Sands -- Beachside At Silver Sands","min":200,"base":245,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"0.0","health_60_day":"0.0","last_date_pushed":"2021-08-24T07:10:28.000Z"},{"id":"115474___260229","pms":"beds24","name":"Blue Bay Beach Getaway -- Blue Bay Beach Getaway","min":250,"base":300,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"73.33","health_60_day":"73.33","last_date_pushed":"2021-08-24T07:10:22.000Z"},{"id":"115477___260232","pms":"beds24","name":"Dolphin Quay Apartment-2 Bedroom -- Dolphin Quay Apartment-2 Bedroom","min":250,"base":250,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"53.33","health_60_day":"58.33","last_date_pushed":"2021-08-24T07:10:24.000Z"},{"id":"115478___260233","pms":"beds24","name":"Canal Elegance In Yunderup -- Canal Elegance In Yunderup","min":250,"base":300,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T07:10:26.000Z"},{"id":"115479___260234","pms":"beds24","name":"Dolphin Quay Apartment-1 Bedroom -- Dolphin Quay Apartment-1 Bedroom","min":200,"base":200,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"53.33","health_60_day":"58.33","last_date_pushed":"2021-08-24T07:10:29.000Z"},{"id":"115481___260236","pms":"beds24","name":"Dolphin Quay Apartment-3 Bedroom -- Dolphin Quay Apartment-3 Bedroom","min":300,"base":300,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"53.33","health_60_day":"58.33","last_date_pushed":"2021-08-24T07:10:29.000Z"},{"id":"115482___260237","pms":"beds24","name":"Delux Living in Wannanup -- Delux Living in Wannanup","min":350,"base":400,"max":null,"push_enabled":false,"health_7_day":"0.0","health_30_day":"0.0","health_60_day":"0.0","last_date_pushed":"2021-02-04T04:20:47.000Z"},{"id":"115486___260241","pms":"beds24","name":"Mandurah Dolphin Escape -- Mandurah Dolphin Escape","min":400,"base":400,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T07:10:35.000Z"},{"id":"115487___260242","pms":"beds24","name":"Luxury Canal Vista -- Luxury Canal Vista","min":200,"base":250,"max":null,"push_enabled":true,"health_7_day":"28.57","health_30_day":"73.33","health_60_day":"83.33","last_date_pushed":"2021-08-24T07:10:33.000Z"},{"id":"115488___260243","pms":"beds24","name":"Living the Dream in South Yunderup -- Living the Dream in South Yunderup","min":155,"base":230,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"30.0","health_60_day":"60.0","last_date_pushed":"2021-08-24T07:10:32.000Z"},{"id":"115489___260244","pms":"beds24","name":"Mandurah Overlooking The Marina -- Mandurah Overlooking The Marina","min":140,"base":200,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"93.33","health_60_day":"96.67","last_date_pushed":"2021-08-24T07:10:32.000Z"},{"id":"115490___260245","pms":"beds24","name":"Madora Bay Beach Break -- Madora Bay Beach Break","min":110,"base":115,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"56.67","health_60_day":"63.33","last_date_pushed":"2021-08-24T07:10:32.000Z"},{"id":"115491___260246","pms":"beds24","name":"Relax At Dawesville Estuary -- Relax At Dawesville Estuary","min":130,"base":165,"max":null,"push_enabled":true,"health_7_day":"42.86","health_30_day":"70.0","health_60_day":"66.67","last_date_pushed":"2021-08-24T07:10:33.000Z"},{"id":"115494___260249","pms":"beds24","name":"The Treehouse In Dawesville -- The Treehouse In Dawesville","min":140,"base":165,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T07:10:35.000Z"},{"id":"115495___260250","pms":"beds24","name":"Surf and Sun in Silver Sands -- Surf and Sun in Silver Sands","min":300,"base":300,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"90.0","health_60_day":"85.0","last_date_pushed":"2021-08-24T07:10:36.000Z"},{"id":"115496___260251","pms":"beds24","name":"Luxurious Mandurah Marina Apartment -- Luxurious Mandurah Marina Apartment","min":300,"base":300,"max":null,"push_enabled":false,"health_7_day":"0.0","health_30_day":"0.0","health_60_day":"0.0","last_date_pushed":"2021-02-05T01:38:57.000Z"},{"id":"115498___260253","pms":"beds24","name":"Waters Edge Apartment with Jetty -- Waters Edge Apartment with Jetty","min":180,"base":240,"max":null,"push_enabled":true,"health_7_day":"57.14","health_30_day":"83.33","health_60_day":"81.67","last_date_pushed":"2021-08-24T07:10:40.000Z"},{"id":"115500___260255","pms":"beds24","name":"Frasers Landing Lifestyle -- Frasers Landing Lifestyle","min":100,"base":108,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"36.67","health_60_day":"68.33","last_date_pushed":"2021-08-24T07:10:37.000Z"},{"id":"115501___260256","pms":"beds24","name":"Relax at Falcon By The Bay -- Relax at Falcon By The Bay","min":145,"base":200,"max":null,"push_enabled":true,"health_7_day":"28.57","health_30_day":"6.67","health_60_day":"48.33","last_date_pushed":"2021-08-24T07:10:44.000Z"},{"id":"115888___260913","pms":"beds24","name":"Water Lover's Haven -- Water Lover's Haven","min":180,"base":180,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"76.67","health_60_day":"88.33","last_date_pushed":"2021-08-24T07:12:56.000Z"},{"id":"115612___260413","pms":"beds24","name":"Delmar Apartment -- Delmar Apartment","min":145,"base":145,"max":145,"push_enabled":false,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-17T07:55:05.000Z"},{"id":"117372___264711","pms":"beds24","name":"Bring your Boat to Dawesville -- Bring your Boat to Dawesville","min":110,"base":130,"max":null,"push_enabled":false,"health_7_day":"0.0","health_30_day":"0.0","health_60_day":"0.0","last_date_pushed":"2021-02-17T01:16:51.000Z"},{"id":"121774___273790","pms":"beds24","name":"Absolute Beach Front Near Mandurah -- Absolute Beach Front Near Mandurah","min":300,"base":365,"max":null,"push_enabled":true,"health_7_day":"57.14","health_30_day":"60.0","health_60_day":"73.33","last_date_pushed":"2021-08-24T08:59:45.000Z"},{"id":"122954___276078","pms":"beds24","name":"Mandurah Estuary Breeze -- Mandurah Estuary Breeze","min":120,"base":165,"max":null,"push_enabled":true,"health_7_day":"57.14","health_30_day":"13.33","health_60_day":"48.33","last_date_pushed":"2021-08-24T08:40:59.000Z"},{"id":"125970___282371","pms":"beds24","name":"Ocean View at Silver Sands -- Ocean View at Silver Sands","min":300,"base":300,"max":null,"push_enabled":false,"health_7_day":"0.0","health_30_day":"0.0","health_60_day":"0.0","last_date_pushed":"2021-08-17T07:58:33.000Z"},{"id":"126927___284308","pms":"beds24","name":"Dolphin Beach Retreat -- Dolphin Beach Retreat","min":110,"base":150,"max":null,"push_enabled":true,"health_7_day":"57.14","health_30_day":"80.0","health_60_day":"90.0","last_date_pushed":"2021-08-24T06:29:30.000Z"},{"id":"130714___291968","pms":"beds24","name":"The Falcon Hangar -- The Falcon Hangar","min":160,"base":200,"max":null,"push_enabled":false,"health_7_day":"28.57","health_30_day":"6.67","health_60_day":"3.33","last_date_pushed":"2021-08-17T07:58:03.000Z"},{"id":"132471___295633","pms":"beds24","name":"Lake Clifton Escape -- Unit 1 - Superior Room","min":90,"base":100,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T08:49:09.000Z"},{"id":"134315___299927","pms":"beds24","name":"Lakelands Hideaway -- Lakelands Hideaway","min":100,"base":110,"max":null,"push_enabled":true,"health_7_day":"0.0","health_30_day":"50.0","health_60_day":"75.0","last_date_pushed":"2021-08-24T08:49:12.000Z"},{"id":"132471___301744","pms":"beds24","name":"Lake Clifton Escape -- Unit 2","min":90,"base":100,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T08:19:05.000Z"},{"id":"132471___301745","pms":"beds24","name":"Lake Clifton Escape -- Unit 3","min":90,"base":100,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T08:19:01.000Z"},{"id":"132471___301746","pms":"beds24","name":"Lake Clifton Escape -- Unit 4","min":90,"base":100,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T08:19:04.000Z"},{"id":"132471___301747","pms":"beds24","name":"Lake Clifton Escape -- Unit 5","min":90,"base":100,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T08:19:03.000Z"},{"id":"132471___301748","pms":"beds24","name":"Lake Clifton Escape -- Unit 6","min":90,"base":100,"max":null,"push_enabled":true,"health_7_day":"85.71","health_30_day":"96.67","health_60_day":"98.33","last_date_pushed":"2021-08-24T08:19:03.000Z"}]

Michael Udinski

If you follow the tutorial closely you will notice that within the Add Record function of the For Each Loop, the fields are mapped to the variable created by the loop and do not reference the index. For example:

name = var: item.name

[Screenshot_2021-08-24_22-44-33.png]

Lachlan McPherson

Hi Michael,

Thanks for your help, it is now working.

For others struggling: I hadn't clicked on the item variable as per the attached screenshot. Instead I had typed with text item.name   - What this did was put plain text into my record in the database that said item.name instead of returning the data i needed. 
https://i.imgur.com/FOWjCKp.png 

Another issue i incurred (which is what happened the first time i tried) was that my database value type for "min" was set to integer, instead of decimal. This was stopping the record from getting updated in the database as well. 

Joe Thong

 
This was the same issue that stumped me for few hours a month ago.  😂

Lachlan McPherson

  😆 it's the small things that can hold you up isn't it lol.