Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use Talend to extract data from Mailchimp. I found some instructions out on Google that indicated I should use the tRest component. I'm unfamiliar with the component and I'm not sure what I'm doing wrong. I'm getting a token error. See attached.
Additionally, when I try use the example that is given with my API key I get an error message that there is an invalid escape character sequence.
Which API methods are you trying to use? If you look in the documentation (https://developer.mailchimp.com/documentation/mailchimp/reference/overview/) it will show you which HTTP method you need to use. You cannot choose whether to use GET, POST, PUT, or DELETE, it will be decided by which API method you use. The API documentation also tells you what parameters are needed. These will change per API method as well.
The invalid escape sequence was likely caused by the Body text you used in your screenshot. It was not formatted properly. First of all it was in a header field, not the Body. You will only get a body field if you use POST or PUT. Secondly, I believe the value was supplied without being surrounded in quotes.
BTW, I don't see the tExtractJSON component in Talend. Is it not available for the component version?
It is the tExtractJSONFields component that you need. It is included in both the open source edition and the paid for edition. Just click on the job canvass and start typing the name. You will see it.