Api importing xml and parse

[TSautier]

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.

[ScottWorld]

I don’t know JavaScript, but if you want to do all of this in a no-code/low-code way that doesn’t require writing any JavaScript code at all, here are some different options for how you can do it.

To import XML files into Airtable, you have 2 no-code ways of doing this:

1. Use Airtable’s XML Import extension.

2. Use Make’s XML importing and parsing tools. I show off how to do this using CSV files (instead of XML files) on this Airtable podcast episode, but you could do the same thing with XML files.

Additionally, if you want to automate the process of communicating with that other API and bringing the data into Airtable, then you have 2 low-code options:

1. Use the DataFetcher extension for Airtable.

2. Use Make’s HTTP modules.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[TheTimeSavingCo]

If it's a one off, use Airtable's XML import extension: https://support.airtable.com/docs/xml-import-extension

If it's going to be continuously pulled (e.g. once a day or something), try Datafetcher: https://datafetcher.com/blog/import-remote-xml-file-airtable