Api importing xml and parse

How To
, ,
1

Hello Guys,

I have a price list table in airtable and I want to update them following sector index.

I use api from the french statistic instute to automate the process but I am not sure which tool to use. I would be keen on just doing an airtable script but I failed, so I am trying to use a Make scenario.

I am able to use the api of the institute with an HTTP Request, the answer is a big xml file which contains basically a large number of series with dates and values for each index in two lists of the index node.
I manage to parse it with XML, but I failed to update the datas either in google sheet or in air table, i manage to do that for 1 line but i have 82 index to create, with 2 parameters for it (date and value).
Basically at the and i want to have 1 column with the dates and 82 column with the values of the 82 index over time

There are plenty of tools but I don’t know which process is the best.

A big Thanks you for your help!

Here is the link to the xml file : https://api.insee.fr/series/BDM/V1/data/INDEX-BT-TP-DIV-IM-2010/?detail=dataonly

2

Welcome to the Make community!

You can either do it via the XML module, or Text Parser, depending on how you want the data extracted.

However, I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.