Extract Mailchimp export list to save into database

[Anonymous]

I'm trying to extract the data returned by the API https://us19.api.mailchimp.com/export/1.0/list/?apikey=xxxxxxx&id=xxxxxxx and pass it to a database, but I can not process the data that comes from the API.

I have no idea how to transform it.

They come in the format
["Field 1", Field 2]
["zxc", "asd"]
["zxcd", "sdasd"]
["zxcv", "asdasd"]

Any help would be good.

Thanks

[Anonymous]

Hi,

    Did you try Talend Data Mapper to do the conversion?

https://help.talend.com/reader/qQd5JCSfrp3wHqpPJnwnKA/th~caW5vwY~xeKVvjGMZsQ

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous · Accepted solution]

Solve the problem by creating a routine, analyzing the text that arrived and converting it to the extent of what was needed.
Thanks for you help me,