Hi! I’m not sure how to go about this and any solution is welcome—I receive through webhooks a field that contains an array separated by commas. These need to be made into records themselves. Depending on the data received, there can be one or 20 values in the array.
Any suggestion on how I can do this? I’m assuming this needs some sort of script, I’m happy as well to be led on what to read so I can learn more on how to do this. Thanks!
@Kevin_Rein_Alvia What you are looking for is automations. There is a trigger called ‘When webhook received’ which will allow you to setup a webhook. Assuming you are passing an array via JavaScript, you can then pass that array as input to a Scripts Action.
Test the webhook following the instructions on the webhook trigger. (See this for documentation)
Pass the array as an input to the Script Action. (See this for documentation)
Use base.getTable("TABLE_NAME").createRecordsAsync(RECORDS_ARRAY) (See this for documentation)
Of course, if the data that is received by your webhook is not in the proper format, feel free to add a step between 2 and 3 which manipulates the array into the right format.