How to send JSON array through graphQL and AWS AppSync to add data to Dynamo Table?

Question

What I'm trying to do is to send data from a React Native app through AppSync so that I can update a user's data on a dynamo table. I can perform all of my CRUD operations, just not a list of data. When I try, I get an error that what I'm sending isn't a valid JSON. However, my input passes as valid JSON when I put it through a JSON linter.

To try and solve this problem, I've changed my input flow to the simplest possible process. Originally I was pulling my JSON from a parsed JSON string that was locally cached. I thought that perhaps there was an issue with the JSON.parse(obj) function. That didn't hold up to reason. So I moved all of my input out of a JS object and into a JSON that isn't stored in a variable beforehand but is directly passed to the API I'm using (https://aws-amplify.github.io/docs/js/api).

After this didn't work, I thought that maybe my GraphQL Schema was wrong for the object type I was sending, but didn't find anything amiss.

My schema in AppSync using GraphQL is defined as follow:

input CreateUserInput {
  email: String!
  data: AWSJSON
}

The request I'm sending is as follows:

const dbReturn = await API.graphql(graphqlOperation(
  mutations.createUser, {
    input: {
      "email": "[email protected]",
      "data": [{
        "num": 34,
      }]
    }
  }
));

The error message says:

"Variable 'data' has an invalid value. Unable to parse [{num=34}] as valid JSON."

What confuses me is that "[{num=34}]" isn't the input I'm giving it. I'm sending it "[{"num": 34}]" which is valid JSON. I would expect it to be able to parse my input and send the data to my dynamo table seeing as the JSON input is valid.

Anybody have any ideas what I can do to get past this? Thank you for the help!

ianarko · Accepted Answer · 2019-07-25 17:34:50Z

21

Figured it out. The answer lies in the GraphQL schema.

"createUser": {
    "email": "Hello, world!",
    "data": "{\"key\":\"value\"}",
}

The input for a "complex data type" is just a string. So when making the request, you just have to pass in the data as something something like JSON.stringify(variable.data). I hope this helps someone along the way.

answered Jul 25, 2019 at 17:34

ianarko

4621 gold badge3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ido Bleicher Over a year ago

it's called escape :)

Ido Bleicher · Accepted Answer · 2020-11-12 14:07:46Z

5

In this image, the sources are AWSJSON type which can hold object or array, if you want to use mutations since it's a JSON object you will need to do escape in order to create the item in the app sync.

answered Nov 12, 2020 at 14:07

Ido Bleicher

8471 gold badge12 silver badges19 bronze badges

Comments

cyberwombat · Accepted Answer · 2019-11-13 15:43:46Z

4

I had the opposite issue. I am not using code to create the query but using gql directly. If I use String in input then I get a stringified JSON in my db which is not what I want. Instead I had to ensure there were no quotes around - in your case, num.

Schema

Item {
 data: AWSJSON
}
ItemInput {
  data: AWSJSON
}

Query

mutation {
 createUser {
   data: { num: 34 } // Not { "num": 34 }
 }
}

This ensures my data is not stored as a string and that on query I get parseable JSON back instead of a quote escaped string.

My VTL templates do do anything unusual on mutations but on query I do return as:

{
  "data" :  $util.toJson($ctx.result.get('data')) // OR $ctx.result.get('data').toJSON()
}

edited Nov 13, 2019 at 15:43

answered Nov 13, 2019 at 14:53

cyberwombat

40.5k43 gold badges189 silver badges268 bronze badges

Comments

Ronak Dholariya · Accepted Answer · 2022-12-15 10:00:04Z

0

Try this.

const dbReturn = await API.graphql(graphqlOperation(
  mutations.createUser, {
    input: {
      "email": "[email protected]",
      "data":JSON.stringify([{
        "num": 34,
      }])
    }
  }
));

answered Dec 15, 2022 at 10:00

Ronak Dholariya

2051 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to send JSON array through graphQL and AWS AppSync to add data to Dynamo Table?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related