Iterate tRest API call with dynamic body

[dura45]

Hi everyone, I'm having trouble with a task and need some help.

I have two tables:

• One with all the products in a CRM - (ImportedProducts)
• One with all the products and prices from an ERP - (PricebookView)

I want to update the prices of all the products in the CRM (ImportedProducts) based on the prices in PricebookView. To do this, I need to make multiple API calls with the following structure:

URL: www.url.com/products/ {productid} where {productid} is dynamic and represents the ID I have in ImportedProducts

BODY (to update the subtotal, for example):

JSON

{
  "subtotal": {price}
}

where {price} is the price for the {productid} in the URL. Of course, there are many prices to update.

I've implemented the basic job functionality, but I'm stuck on how to pass dynamic values to the URL and body. Any suggestions? Thanks!

Here the actual job has an error (Syntax error on token "") }"", delete this token. But I think this is not only a syntax error but a structure error.

Talend Studio 

[Shicong_Hong · Accepted solution]

Hello

You need to escape the double quotes in the body string, eg:

"{\\"key\\":value}"

Regards

Shong