Talend Development

[SreejithSL]

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

[SreejithSL]

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

[SreejithSL]

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