topic Re: Data types in document from tWriteJSONField in Talend Studio

Data types in document from tWriteJSONField

Anonymous — Sat, 16 Nov 2024 11:42:04 GMT

I'm trying to send a POST request to a REST service of JSON format. I am using the tRestClient component which requires an input schema of
body (type: document)
string (type: string)
The service requires a request schema:

{
    "ID": Integer,
    "Name": "String"
}

When I send the JSON to the tRestClient component, I am getting a Bad Request Exception, I believe it's because the output of tWriteJSON field is outputting column1 as a string rather than an integer (i.e. it is enclosed in double quotes). You can see this in the code below.
How do I manipulate the data types of the values from the tWriteJSONfield component, while still keeping the output schema of type document (as is required for the tRestClient component).

 connecting to socket on port 3534
 connected
09:57:20,351 INFO   Using default type string
|{"ID":"34842","Name":"Name1"}
Exception in component tRESTClient_3
javax.ws.rs.BadRequestException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at org.apache.cxf.jaxrs.client.AbstractClient.convertToWebApplicationException(AbstractClient.java:452)
        at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:858)
        at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:829)
        at org.apache.cxf.jaxrs.client.WebClient.invoke(WebClient.java:392)
        at org.apache.cxf.jaxrs.client.WebClient.post(WebClient.java:418)
        at vu_mdm_title.writeback_0_1.Writeback.tWriteJSONField_1_InProcess(Writeback.java:5833)
        at vu_mdm_title.writeback_0_1.Writeback$1ThreadXMLField_tWriteJSONField_1_Out.run(Writeback.java:3329)
 disconnected
Job Writeback ended at 09:57 27/03/2014.

If I set the output of tWriteJSON to be of type int and string (instead of document and string) then the tRestClient component throws a "body/string cannot be resolved" error.

Re: Data types in document from tWriteJSONField

Anonymous — Fri, 28 Mar 2014 02:16:39 GMT

Hi
To pass a request with json format to a rest web service, use a tXMLMap, instead of tWriteJsonField, to build a document before tRestClient, and select json option from the accept type list on tRestClient.
Shong

Re: Data types in document from tWriteJSONField

Anonymous — Fri, 28 Mar 2014 15:19:55 GMT

Hi Shong,
How do I build a JSON with the tXMLMap component?
My understanding is that it would output an XML document like
<root>
<ID> 1234 </ID>
<Name> "Name" </Name>
</root>
which isn't what I need. My initial input is 2 columns, which I need to format into a JSON before it goes through to the tRestClient component.

Re: Data types in document from tWriteJSONField

Anonymous — Mon, 31 Mar 2014 06:09:44 GMT

bump. Shong could you please expand on your answer?

Re: Data types in document from tWriteJSONField

Anonymous — Thu, 17 Apr 2014 04:27:48 GMT

What is the work around to this issue?
Still seems to be a major problem:
https://jira.talendforge.org/browse/TDI-25966?page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel

Re: Data types in document from tWriteJSONField

Anonymous — Thu, 17 Apr 2014 10:54:05 GMT

Hi.
These are the options I'm aware of:
- Use tXMLMap with tRESTClient - this relies on the internal CXF DOM4J (XML) to JSON auto conversion. If you go this way then you can also have the root dropped, etc, there are few JSON related properties in tRESTClient/Advanced
- Use other Studio components to create JSON in the String format - and feed it directly into tRESTClient, bypassing tXMLMap
Does it help a bit ?
Sergey

Re: Data types in document from tWriteJSONField

Anonymous — Thu, 17 Apr 2014 11:14:41 GMT

Hi,
Suggestion by shong to create a json file
http://www.talendforge.org/forum/viewtopic.php?pid=132391
Vaibhav