I have json type field on Postgres and trying to create object type in GraphQL but compiler issuing error:
== Compilation error in file lib/community_web/schema.ex ==
** (Absinthe.Schema.Error) Invalid schema:
/Users/kishore/CodeLearning/Elixir/community/lib/community_web/schema.ex:21: Values :json is not defined in your schema.
The json db type may have an array or a map with unstructured keys. Unstructured data is strictly forbidden in GraphQL, so you’ll need to work around it. You have two primary options:
If you are storing semi-structures data in the field (like a list of strings, of a map with a few possible keys), then make an object with those fields.
If you have arbitrary data in there then you can send it as a string and have the client decode it.
In our primary GraphQL API we use both of these techniques.
One caveat, if you do go with option 2: enforce the size of the arbitrary data that can be stored. For example, if you have a meta field with client provided values you should restrict the serialized JSON to a fixed length. We do this and limit data to 1024 characters.
In Absinthe :json is not built-in and you need to add it to your project manually. Generally speaking you want to be cautious on over-relying on untyped JSON in GraphQL, but a JSON field in Postgres sounds like a good use case to me
Here are the instructions for adding a custom JSON type in Absinthe:
I don’t know GraphQL well enough to try to help with the immediate problem, but there is a deeper conceptual problem going on here. JSON is not a data type. It is an encoding format. Even though that is the “field type” in the database, you conceptually have some sort of business domain type you are storing that way. That business domain type is what you should expose via GraphQL.
Exposing your field as a “json type” is basically working against the GraphQL goal of specifying your types explicitly. If you are not very careful, this will become a maintenance problem over time.