Iterate tRest API call with dynamic body

dura45 — Fri, 19 Apr 2024 13:16:38 GMT

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.

Re: Iterate tRest API call with dynamic body

Shicong_Hong — Mon, 22 Apr 2024 10:03:30 GMT

Hello

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

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

Regards

Shong

topic Iterate tRest API call with dynamic body in Talend Studio

Iterate tRest API call with dynamic body

Re: Iterate tRest API call with dynamic body