topic Re: GraphQl in Talend in Talend Studio

GraphQl in Talend

Anonymous — Sat, 16 Nov 2024 05:24:42 GMT

Hi everyone,

I have to use a GraphQL API in talend but I can't do it.

The goal is to get data from another API with a tjava, then i link the tjava with a tmap and to finish i use the tmap to do a request like : '{"query": "mutation { saveForm(formInput: {wasteDetails{name : ' + row1.wdName + '}) {id,wasteDetails{name}} }" }'

I try 3 differents way.
The first way was with tRest but we can't link a tmap to a tRest

The second way was with a tRestClient but I don't know what put in parameters in my url so I've had a http 500 errors

And the third way was with thttprequest but i don't know how to use the row of my tmap in my file for the post of the thttprequest

I hope I'm clear enough

Thank you in advance

Re: GraphQl in Talend

Anonymous — Tue, 02 Jul 2019 09:35:27 GMT

Can you send a screenshot of your job as it is at the moment? It sounds like you are using a Java API (via an imported Jar?) to get your data. You are then building an JSON String with your tMap and then trying to send that to a web service?

If that is correct, I would use a tRestClient to call GraphQL and ensure that your send the JSON via the string column (tRestClient needs either a string or body column....string for JSON, body for XML).

Re: GraphQl in Talend

Anonymous — Tue, 02 Jul 2019 13:15:32 GMT

My job looks like that :

My tjava :

The result is a huge xml.

My tExtractXMLField_1 :

And my tmap :

The result of this job is :

These are the results I want to put in the graphQl api.

So i call an API, this API sends me a xml. With extractXML I take all the datas and they go in my tmap.
Now I have to put these datas in the tRestClient with a query like : '{"query": "mutation { saveForm(formInput: { id: '+ row3.WTIERS +', ....}) {id,wasteDetails{name}} }" }'

To do that I have to use a twritejson ?

Re: GraphQl in Talend

Anonymous — Tue, 02 Jul 2019 14:22:00 GMT

First, connect your tRestClient to your tMap. You should see a body and a string column in your tMap output table. In your tMap output table's string column value expression, use this code....

"{\"query\": \"mutation\", { \"id\": \""+ row3.WTIERS +"\"}}"

......note the above code is abridged since the code you supplied was not complete. Note the "\" characters used to escape the quotes. You need to keep this in mind with Java String manipulation.

Once you have done this, you just need to make sure the tRestClient is configured with the correct endpoint and details.

You may want to test the JSON being produce by replacing the tRestClient with a tLogRow.

Re: GraphQl in Talend

Anonymous — Tue, 02 Jul 2019 14:38:44 GMT

It works, thank you very much.

Re: GraphQl in Talend

Anonymous — Fri, 25 Oct 2019 19:47:55 GMT

Hello Everyone,

I am facing the similar issue while performing the mutation operation

I was able to Query and receive the response as well

But while performing the mutation talend is throwing an error like below

Please find my Job Screenshots attached.....

Re: GraphQl in Talend

Anonymous — Mon, 28 Oct 2019 11:46:49 GMT

It seems to suggest an unexpected character has been used in the JSON you are sending. Can you post the JSON here?

Re: GraphQl in Talend

Anonymous — Mon, 28 Oct 2019 17:13:10 GMT

mutation { importEntities: {name: "ABC World"} {id} }

This is the JSON I am trying to POST

Thanks,

Archanalg

Re: GraphQl in Talend

Anonymous — Mon, 28 Oct 2019 17:22:08 GMT

Hi rhall,

mutation{ upsertEntity(entity: { name:"ABC World"}) {id}}

when I try to post the same JSON in GraphQL Playground Link I am able to receive response,

Please let me know is there any specific component designed to handle GraphQL calls.

Thanks in advance,

Archanalg

Re: GraphQl in Talend

Anonymous — Mon, 28 Oct 2019 17:29:12 GMT

This is bad JSON. It does not fit JSON standards. Test your JSON out here before posting it. It will help you identify what is wrong with it

Re: GraphQl in Talend

Anonymous — Tue, 29 Oct 2019 05:23:56 GMT

Hello rhall,

sorry for my bad JSON , actually that is my GraphQL mutation statement.

Could you please let me know how to pass it to graphql server through trestclient.

or if there is any alternative way.

Thanks in advance

Re: GraphQl in Talend

Anonymous — Tue, 29 Oct 2019 09:01:07 GMT

Your tRestClient has a string and a body input schema. The body column is for XML (document) and the string is for JSON. Send the JSON to the string column using the component before to set it. When formatting the JSON you will need to make sure you handle all of the formatting. Therefore you will need to build it using Java escape characters to escape the quotes.

Re: GraphQl in Talend

Anonymous — Tue, 29 Oct 2019 11:01:04 GMT

I have taken your advice and quoted all the strings as shown in the attached pictures,

still getting "post body missing error".

Request you to help us out as it is priority issue to us and we are able to find very less posts on GraphQL - Talend combination.

Re: GraphQl in Talend

Anonymous — Tue, 29 Oct 2019 11:21:39 GMT

How is your tFixedFlowOutput configured? Your JSON is still not correct. You are missing a few colons.

Re: GraphQl in Talend

Anonymous — Tue, 29 Oct 2019 11:29:33 GMT

the below is mutation statement and i am storing it in a context variable jsonString which is passed to fixedflow

context.jsonString = "\"mutation\"{ \"upsertEntity\"(\"entity\" : { \"name\" : \"ABC1 entity \" }) {\"id\",\"name\"}}";

please let me know how to correct the JSON format.I have minimum knowledge on JSON formation.

Re: GraphQl in Talend

Anonymous — Thu, 31 Oct 2019 06:06:33 GMT

Hi rhall,

please help as I stuck here still.

Thanks in advance,

archanalg

Re: GraphQl in Talend

Anonymous — Thu, 31 Oct 2019 09:53:49 GMT

Before creating it as a Java String, take the JSON you have created and test it here. This will tell you where it is incorrect. I can see from glancing at it that you are missing semicolons (. For example, your current code is this...

"\"mutation\"{ \"upsertEntity\"(\"entity\" : { \"name\" : \"ABC1 entity \" }) {\"id\",\"name\"}}"

It looks like ":" is missing after "mutation" and "upsertEntry". I'm also not sure that what you are trying to do with the "(" and ")" characters. Can you give a bit more detail on what needs to be provided to the service? Is there any API documentation?

Re: GraphQl in Talend

kakooo16 — Tue, 07 Apr 2020 14:49:21 GMT

Hello rhall ,

Im stuck with passing a query to my tRESTClient using GraphQl.

It is working on Postman and im getting the right informations but using talend i couldn't pass the query .

Thanks in advance .

ql.PNG
ql1.PNG
ql2.PNG

Re: GraphQl in Talend

kakooo16 — Wed, 08 Apr 2020 14:15:26 GMT

Hello ,

Is there anybody who can help .

Re: GraphQl in Talend

Anonymous — Wed, 22 Apr 2020 00:26:24 GMT

Sorry @kakooo16, I have not been on the Community for a while. From what you have said, it looks like you are not sending your JSON query to the string column of the input schema. You will also need to set the tRestClient http method to POST