How can I use Hasura with a GraphQL query to project the fields of the results into the required JSON format?

[AkshayBhatHasura]

I am able to connect to two different databases from Hasura and query and obtain results, but the obtained JSON has to be tweaked to fit my needs.

[sumedh-1]

Here is a reference to the same original query in Twitter

[code-sumedh]

[code-sumedh]

How much longer do I have to wait for someone to initiate the discussion with me?

[manasag]

Hi @code-sumedh, can you provide example of what kind of transformation you are aiming for. Naming Conventions feature provide some customizations around renaming fields.

[code-sumedh]

Hi @manasag,

My query is as below (queries two different databases using Hasura and obtain results):

and this is the response:

but the obtained JSON has to be tweaked to fit my needs as below:

[manasag]

Thanks for the details. I would say that this is a data union usecase; where we have same schema across different databases; and we want to collate results across different databases into a single graphql root field.

This is not supported in Hasura as of now. We think that in future that some of these usecases which can be very custom, can be solved by writing your own connector, in a easy to code against SDK in Hasura V3. V3 is due beta launch in August. I would like to convert this discussion to an issue, so that we continue this discussion as a feature request and provide further updates.