Skip to main content

I have a script that calls an API and writes the JSON objects to my table. This has hit the limit of what I know about scripting.


Can anyone help modify my script so that on the next call, it will update any records that exist and insert any records that are new.


I assume I need an IF statement to look for an existing ID and validate if the associated string matches ELSE create a new record.


My existing script is:

let response = await remoteFetchAsync(“APIURL”, requestOptions);

let json = await response.json();


let table = base.getTable(“Titles”);

for (i=0; i < json.length; i++) {

let recordId = await table.createRecordAsync({

“Title”: jsonti].Title,

“ID”: json>i].ID

})

};


Thanks!

Welcome to the community, @Dave! :grinning_face_with_big_eyes: Here are a couple of tips that should get you a little further (if you haven’t already solved this).


First, I recommend switching your looping mechanism to use the for...of syntax:


for (let item of json) {

...

Then you would access properties of the item like this: item.Title. Unless there’s a need to use the index of the item in the original array, this is a more streamlined approach.



You’re definitely thinking in the right direction. I recommend looking into the find() array method, and using that to locate a matching record from the table. If found, do what you want with the matching record; otherwise create a new one.

Reply


Terms & Conditions