Hello,
I have a price list table and I want to update them following sector index.
I will use api from the french statistic instute to automate the process but I am not sure which tool to use. I woyld be keen on just doing an airtable script.
I am able to use the api of the institute (but I don't know how to code it into airtable script), the answer is a big xml file which contains basically a large number of series with dates and values for each in two lists of the node serie X. What I want is to be able to parse this xml to merge the dates because there are the same and put it in a column and create one column for one index with the value.
There are plenty of tools but I don't know which process is the best.
Thanks you for your help!
If required, I can attach the xml response file.