topic Re: How to pass dynamic (body) values to tREST in Talend Studio

How to pass dynamic (body) values to tREST

kakooo16 — Sat, 16 Nov 2024 02:40:39 GMT

Hello ,

So , im trying to a dynamic value to a tREST body query : (here is a screen shot of my trest configuration) :

to Explain more im getting an error as below :

When i use static values it works .

my job is as such :

I think that i have a syntax error in the query .

Hope this problem would be solved .

Thanks again .

Re: How to pass dynamic (body) values to tREST

TRF — Wed, 15 Apr 2020 17:11:01 GMT

You need to use strings concatenation like this:

"{\"query\":\" blablabla
       product_simple_ids : [" + ((List)globalMap.get("myList")).get(i) + "]) blabla...

Re: How to pass dynamic (body) values to tREST

kakooo16 — Wed, 15 Apr 2020 17:20:01 GMT

Hello TRF ,

It seems like the error is caused by

((List)globalMap.get("myList")) : however the double quaotes are note supported in query ,so i ve put an \ to avoid them . But , seems that the problem still persist

Re: How to pass dynamic (body) values to tREST

kakooo16 — Wed, 15 Apr 2020 17:24:01 GMT

Here is my new query :

product_simple_ids: [ \\\"+((List)globalMap.get(\"myList\")).get(i)+\\\" ])

Re: How to pass dynamic (body) values to tREST

kakooo16 — Wed, 15 Apr 2020 18:16:26 GMT

Is there a possible way to pass dynamic global variables and support the double quotes (") : such example :

product_simple_ids: [ \\\"+((List)globalMap.get(\"myList\")).get(i)+\\\" ])

Im still blocked and needs some help please .

Thanks in advance .

Re: How to pass dynamic (body) values to tREST

TRF — Wed, 15 Apr 2020 18:51:40 GMT

The basic rule you have to respect is that fixed parts must be between " but not variable parts issued from variables. Inside fixed parts, " must be protected by \.
Here is an example:
"a fixed string with \" inside"

Re: How to pass dynamic (body) values to tREST

kakooo16 — Wed, 15 Apr 2020 20:20:52 GMT

Thanks for your helpful advice ! I get it now but i have an other error . as shown below :

In the first line am printing my global variable OK but it seems like it is treated separtrly (in blocs ) some how as in the screenshot .

I don't realy get the error !

Any idea ?

Re: How to pass dynamic (body) values to tREST

TRF — Wed, 15 Apr 2020 20:57:05 GMT

Can't see the problem. Body field contains \n so it's printed on multiple lines. If it disturb the next component behaviour, remove them with something like row1.body.repalceAll("\n", "")

Re: How to pass dynamic (body) values to tREST

kakooo16 — Wed, 15 Apr 2020 21:03:47 GMT

And for the first element treated im getting this :

marketplace_product_id to be  treated ==3ME-K110032032
.----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------.
|                                                                                                                                          tLogRow_1                                                                                                                                          |
|=---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------=|
|Body                                                                                                                                                                                                                                                                              |ERROR_CODE|
|=---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------=|
|{
    "errors": [
        {
            "message": "Syntax Error: Invalid number, expected digit but got: \"K\".",
            "locations": [
                {
                    "line": 1,
                    "column": 130
                }
            ]
        }
    ]
}|null      |