topic Re: Talend Development in Talend Studio

Talend Development

SreejithSL — Fri, 15 Nov 2024 22:42:06 GMT

Hello All,

It would be better if anyone can share the experience on working with Amazon SP-API connecting to Redshift with talend. We have one use case to get our sales data from SP-API and load to redshift daily basis.

your inputs would be more helpful.

Thanks .

Sreejith

Re: Talend Development

Anonymous — Fri, 29 Jul 2022 04:44:38 GMT

Hello,

Are you referring to Amazon selling partner API?

With the target output, you are able to write your data into Redshift Via tRedShiftOutput component in talend.

Best regards

Sabrina

Re: Talend Development

SreejithSL — Fri, 29 Jul 2022 11:05:02 GMT

Hello Sabrina,

Thanks for your reply.

Yes you are right I am referring to amazon selling partner API.

My primary question is, can we connect to the seller API through tRest_Client component , since I am yet to get the SP API details and in the learning phase to understand about the API

Thanks,

Sreejith

Re: Talend Development

Anonymous — Mon, 01 Aug 2022 01:38:08 GMT

Hello,

Talend tRest_Client can connect Rest API. It interacts with RESTful Web service providers by sending HTTP and HTTPS requests using CXF (JAX-RS) getting the corresponding responses.

Could you please give us any specification about amazon selling partner API?

Best regards

Sabrina

Re: Talend Development

SreejithSL — Wed, 03 Aug 2022 12:59:17 GMT

Hi Sabrina,

There are a lot of APIs documentation mentioned in the following link.

https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference

The challenging part is I am still not aware of generating a bearer token to authenticate the SP-API with tRest_Client component or may be which authentication can be used to pull the json data from the API.

Thanks.

Sreejith

Re: Talend Development

SreejithSL — Thu, 11 Aug 2022 12:35:31 GMT

Hi Sabrina,

Do you have any insight about this .

Thanks,

Sreejith

Re: Talend Development

SreejithSL — Thu, 10 Nov 2022 14:44:02 GMT

Have you already got a solution to connect Amazon SPI and get data . If , could you share the idea then.

Thanks,

Re: Talend Development

Anonymous — Fri, 11 Nov 2022 09:32:18 GMT

Hello,

Here is the related topic about using OAuth authentication for the API to get the data.

https://community.talend.com/s/question/0D55b00007stcLPCAY/talend-development

Best regards

Sabrina

Re: Talend Development

SreejithSL — Fri, 11 Nov 2022 11:24:42 GMT

Thanks Sabrina for referring to this again , now I can generate the access token . The next I have to access the API end point using this access token generated , may be I have to so this based on the API specification doc, however , if you know how to make a call to amazon Brand Analytics API then it would to better to share as well.

Re: Talend Development

Anonymous — Mon, 14 Nov 2022 03:13:16 GMT

Hello,

Could you please also share this API specification doc here? We will check it to see if there is a way to make a call to amazon Brand Analytics API in talend.

Best regards

Sabrina

Re: Talend Development

SreejithSL — Wed, 23 Nov 2022 14:12:52 GMT

Hi Sabrina,

This is the document which I am referring to make a get request to get the brand anlaytics data.

https://developer-docs.amazon.com/sp-api-blog/docs/getting-started-with-selling-partner-api-for-vendors.

Now I can successfully generate a bearer token which is valid for 3600 sec through talend, the next is to make a get call using the bearer token to access the data, my market place ID is belongs to germany and really confusing how to generate the end point.

Thanks,

Sreejith

Re: Talend Development

SreejithSL — Wed, 23 Nov 2022 14:55:24 GMT

Hello,

First we have to generate a bearer token ,for that make a POST request using tRestClient with query parameters ,

"grant_type" ="refresh_token", "refresh_token","client_id","client_secret" . The last three parameter should be generated from the ventor portal API integration developer centre then we would get a json response with "access_token"

If you already generated the bearer token , then please share the idea to create an endpoint to perform GET request to pul data from the reports API.

Thanks,

Sreejith