topic Re: Column name is an integer in Talend Studio

Column name is an integer

Informatique1 — Fri, 15 Nov 2024 22:47:43 GMT

Hello,

I use tWriteJsonField to send it into the body of an API.

The problem is that one of the field needed for the API is a number:

How can I do it?

Thanks

Re: Column name is an integer

gjeremy1617088143 — Fri, 24 Jun 2022 12:31:32 GMT

HI, here a workaround , you can name your attribute with non special char then after change it with the one you want with a tReplace component for example.

Send me love and kudos

Re: Column name is an integer

Informatique1 — Fri, 24 Jun 2022 14:18:04 GMT

Thanks, but I don't see how tReplace can change the name of the column when it only change the value?

Re: Column name is an integer

gjeremy1617088143 — Fri, 24 Jun 2022 14:21:17 GMT

if your output is a type String, you can replace all you want in with a tReplace so you can name your attribute with a really specific Name like @attributeToChange for example and then looking for this and replace it with is real name here 1473

Re: Column name is an integer

Informatique1 — Mon, 27 Jun 2022 12:01:59 GMT

I seriously don't see what I'm supposed to do to change the column name and not the value 😕

Re: Column name is an integer

gjeremy1617088143 — Mon, 27 Jun 2022 13:25:03 GMT

If the output of your tWriteJsonField have a field of type String wich contain your Json, you can use a tReplace on it, so you'll overwrite all you want in the json, before sending it to the api.

tWriteJsonField -->tReplace--> tRestClient

Re: Column name is an integer

Informatique1 — Mon, 27 Jun 2022 14:16:47 GMT

I tried: tWriteJsonField -->tReplace--> tRestClient

With:

output column of my tWriteJson

inside tReplace:

The result is still the same in the log:

{"rootTag":{"data":{"@id":"5960","attributes":{"element":{"@idContext":"0","@idLanguage":"1","@value":"1880"}}}}}

It does not change the element name by 1473.

Re: Column name is an integer

gjeremy1617088143 — Mon, 27 Jun 2022 14:35:11 GMT

uncheck wole word checkbox in the tReplace will do the job

Re: Column name is an integer

Informatique1 — Mon, 27 Jun 2022 15:30:30 GMT

I'm still getting a 400 bad request.

It does not change if I send with tWriteJson or a simple string that looks like a Json. The tRestClient don't take it, in the string or the body.

I use Patch/Json/json.

Perfectly working on postman but nothing in the studio 😕

Thanks for your time and answers.

Re: Column name is an integer

gjeremy1617088143 — Mon, 27 Jun 2022 15:41:41 GMT

have you tried to do it via postman before try it into talend ?

Re: Column name is an integer

Informatique1 — Tue, 28 Jun 2022 07:03:40 GMT

Yes and it works fine. Not the first time I use tRestClient on Talend on POST and GET request.

Here on a PATCH, don't know why it does not take the Json I send while in Postman I just do that:

Re: Column name is an integer

gjeremy1617088143 — Tue, 28 Jun 2022 09:12:04 GMT

ok it seems you dont have the array in your json created by talend

you can do it with

name your root node root instead of rootTag

adding an attribute on the root node

name class

fixed value (right click on the attribute and choose fixed value)--> array

add a sub element named root to the root node

add your data sub element to the root sub element

then you check remove root node in the component

root

@class array

---- root

--------- data

-------------- type

--------------attributes

Re: Column name is an integer

Informatique1 — Thu, 21 Jul 2022 14:41:38 GMT

Hi,

Sorry for late answer I had some projects to finish first... And thank you for your help and patience.

So I tried as you mentioned:

Unfortunatly it still don't work.

It send this:

{"rootTag":{"data":{"id":"XXXXX","type":"objects","attributes":{"1473":{"idContext":"0","idLanguage":"1","value":"XXXX"}}}}}

I tried to directly sent a string to look like the one I send in postman:

I don't know what I'm missing. I tried to send it into the String or the Body of the API but no result: still a 400 bad request 😕

Re: Column name is an integer

Informatique1 — Mon, 25 Jul 2022 12:31:16 GMT

So finally I manage to create a simple String in a T_Java to make my Json inside an array []. As it was impossible with tWriteJsonField which always start by

{"root", [...data...]}.

And it works 🙂

Sometimes the easiest way is the best^^

Oh and not in the body but in the string of the API. And activating the "Log messages" option in Advanced settings in the tRESTClient is VERY helpfull.

Thanks gJeremy for your time and your help 🙂