topic Mapping JSON from API Rest to SQL Table in Pipelines

Mapping JSON from API Rest to SQL Table

Anonymous — Wed, 17 Jul 2024 08:58:36 GMT

Good morning.

I am asking a REST API and I obtain a JSON like this:

I want to map all records but it is storing only the first record of the JSON:

How can i do to store all records of the collection?

Thank you in advance

Anonymous — Thu, 18 Jul 2024 08:21:56 GMT

Hi Anonymous ,

It may be necessary to parse the JSON data and insert it into the SQL table with the help of python.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.