Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Token error using tRest in Talend

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.

Labels (3)
14 Replies
Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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. 

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

BTW, I don't see the tExtractJSON component in Talend.  Is it not available for the component version?

Anonymous
Not applicable
Author

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.