topic Extract Mailchimp export list to save into database in Talend Studio

Extract Mailchimp export list to save into database

Anonymous — Wed, 03 Jul 2019 22:46:42 GMT

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

Re: Extract Mailchimp export list to save into database

Anonymous — Thu, 04 Jul 2019 01:56:10 GMT

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 🙂

Re: Extract Mailchimp export list to save into database

Anonymous — Tue, 09 Jul 2019 14:30:44 GMT

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,