You can translate the question and the replies:

Excellent tutorial. Need help with filters resolvers

Thanks for tutorial. I got great Idea. Can you help me How your Query resolver? You explained filters. But I have JSON data . I need to execute this Query on JSON Data.

3 Answers

Hi, In Denodo, the GraphQL Service automatically creates the GraphQL schema from the metadata of the views and stored procedures of a Denodo virtual database. With associations being defined among the views, GraphQL queries are capable of fetching related objects and their fields in one request. For querying JSON data, I would create a **[JSON datasource](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources#json-sources)** in Virtual DataPort Admin Tool and create a base view from it. Then, I would invoke the view using any external GraphQL application such as GraphQL Playground using the URL **http://<host>:<port>/denodo-graphql-service/graphql/<database>** You could also use the query resolver in the GraphQL application to merely orchestrate the invocation of resolver functions. You can take a look at the **[Denodo GraphQL Service](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/restful_architecture/graphql_service/graphql_service#denodo-graphql-service)** section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
02-02-2021 06:53:34 -0500
It's good, but I connect to any other system one I got DataSet.
user
02-02-2021 11:13:12 -0500
Hi, You can connect to a wide range of structured, semi-structured and unstructured data sources such as Databases, Websites, Spreadsheets, XML documents, Web Services, LDAP servers, Flat text files, etc from Denodo Platform. After this, you could create base views from it, **[join](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_join_views/creating_join_views#creating-join-views)** these base views into a derived view and consume these views using **[Denodo GraphQL Service](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/restful_architecture/graphql_service/graphql_service#denodo-graphql-service)**. You can take a look at the **[Creating Data Sources and Base View](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/creating_data_sources_and_base_views#creating-data-sources-and-base-views)** section of Virtual DataPort Administration Guide for detailed information. Hope this helps!
Denodo Team
15-02-2021 06:36:52 -0500
You must sign in to add an answer. If you do not have an account, you can register here