aws / aws/aws-appsync-community

Graphql schema always return null value from RDS Aurora Serverless

Open
#170 0 comments 0 reactions 0 assignees View on GitHub
question
Dominant language
HTML
Stars
507
Forks
37
PR merge metrics
No merged PRs in 30d

Description

Hai.
i'm using reactjs for develop an app. then, appsync as graphql server and rds aurora serverless as database. after connecting all of components, i have problem with return value. value is always null like on picture.

here's my graphql schmea
`type Query{
listUsers: [user]
}`

here's my resolvers
request
`{
"version": "2018-05-29",
"statements": ["SELECT * FROM User"]
}`
and response
`$utils.toJson($utils.rds.toJsonObject($ctx.result)[0])`

here's the result from aws graphql console
![aws_1](https://user-images.githubusercontent.com/40979473/123409132-0ba5ce80-d5d8-11eb-8eb4-0dcf2bf22f52.png)

thanks, i hope there a resolver to hlep me fixing the problem. i'am sorry about my language, thanks a lot.

Contributor guide

Open the contributing guide

Research direction

Start with the GraphQL schema, the AppSync resolver request and response templates, and the AWS GraphQL console result shown in the issue. Trace the listUsers path through RDS Aurora Serverless and verify that the resolver returns the queried user values rather than null; done means the console returns populated values.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, graphql, react
Domain
api, cloud, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.