topic Re: Token error using tRest in Talend in Talend Studio

Token error using tRest in Talend

Anonymous — Fri, 05 Apr 2019 21:52:06 GMT

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.

Re: Token error using tRest in Talend

Anonymous — Fri, 05 Apr 2019 21:53:22 GMT

Here's a screenshot showing the parameters I put in also.

using trest on Talend.PNG

Re: Token error using tRest in Talend

Anonymous — Sat, 06 Apr 2019 00:13:01 GMT

Hi @gfred,

It looks like you have a compilation error. I would recommend connecting a tLogRow to your tRest component. You have also not configured your tRest component incorrectly. You have set the body as a header and you have used unescaped quotes in the String. This will be the cause of your compilation issues.

Can you post a link to the mailchimp API documentation that you are using as this might help us help you out.

You posted a screenshot with your API key in it. This is not advisable since it could give access to other people to your mailchimp account. I have therefore removed the image.

Re: Token error using tRest in Talend

Anonymous — Sat, 06 Apr 2019 00:42:12 GMT

Here's a link to the article I was referring to.

Re: Token error using tRest in Talend

Anonymous — Sun, 07 Apr 2019 21:19:40 GMT

Hi @gfred, I cannot see the link

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 14:35:29 GMT

https://intodata.eu/connecting-to-salesforce-and-mailchimp-using-talend/

Here is the link that you requested.

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 15:18:48 GMT

It looks like there are several things wrong here. First of all, the API method you are using is for creating a list in mailchimp. I don't think that is what you want to do. It is also a POST method, yet you are using GET. The "Body" header is not needed there. If you set the Http Method to POST, you will see a Body section appear. This is a Java String, so must be surrounded with quotes (.....if it contains quotes, they must be escaped). The example shown in the documentation you have given me is formatted to escape quotes...

“{\”apikey\”: \”your api key will be here\”,\”cid\”: \”put a campaign id here\”}”

The '\' characters are there to escape the following '"' characters.

If you look at the MailChimp API documentation (https://developer.mailchimp.com/documentation/mailchimp/reference/overview/) you will see how the method calls should be built and what parameters are needed. To start with, you need to pick an API method

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 15:32:21 GMT

I'm trying to understand what components I should be using from the Talend side and how to use them. You are correct, I am trying to pull data from Mailchimp into Snowflake using Talend.

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 15:37:48 GMT

You first need to understand the MailChimp API and how to use it. You can test this out by using a tRest and tLogRow component. Once you have been able to extract the data you need from the MailChimp API, you will need to figure out how to extract it from JSON format. You can use a tExtractJsonFields component for that. Once you have got the data you want out of the JSON String, you will need to work out where you want it in Salesforce and how to get it there.

I suggest you start with just trying to get the data out of MailChimp first.

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 15:48:23 GMT

That's what I'm trying to do. But I'm confused. If I'm trying to use the get HTTP method and the Body isn't necessary as you mentioned then where do I give the component the API key to use to pull the data with?

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 16:02:43 GMT

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.

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 16:14:58 GMT

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.

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 16:17:27 GMT

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.

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 17:02:29 GMT

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

Re: Token error using tRest in Talend

Anonymous — Mon, 08 Apr 2019 17:47:05 GMT

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.