Appsync composite key (GSI in dynamodb) returns Null in query response

Question

Hi, I have a appsync Schema which has composite key

@key(name: "FinderJobbyDateWithCompositKey", fields: [ "finder_id", "date", "job_status" ], queryField: "JobsFinderWithCompositKey")

I did amplify push and it successfully created GSI with the respective table. the table has the data but when I run query

query MyQuery {
  JobsFinderWithCompositKey(finder_id: "+929898989898", dateJob_status: {eq: {date: "2022-04-06T09:00:00.000Z", job_status: "15"}}) {
    items {
      cod_charge
      createdAt
    }
  }
}

it give me Null in response. 
Please specify what is the issue and how to solve and get result.

I followed this link:

https://docs.amplify.aws/cli-legacy/graphql-transformer/key/#example-get-orders-by-customer-email-by-createdat

Answer

Hello Shaista,

I understand that you followed this [guideline](https://docs.amplify.aws/cli-legacy/graphql-transformer/key/#example-get-orders-by-customer-email-by-createdat) to make Amplify push, which successfully created GSI in the corresponding DynamoDB table. The table has expected data, however when you run the query, it is giving you null response. We need additional account specific information in order to troubleshoot this issue. Hence, kindly, reach out to [AWS Support](https://docs.aws.amazon.com/awssupport/latest/user/case-management.html) and work with Premium Support Engineers to resolve this issue. While creating the support case to Premium Support, you will need to provide following details.

•	Account ID
	•	Region
	•	Table Name
	•	GSI name
	•	Time frame(10-15 minutes window)
	•	DynamoDB Request ID(Important)

Appsync composite key (GSI in dynamodb) returns Null in query response

Relevant questions

Appsync - DynamoDB from Amplify very slow response times

Appsync GSI not producing existing DynamoDB record by Graphql using amplify

AWS AppSync gives Unauthorized Access

AppSync BatchGetItem issues

Are there any cases lead to "Query condition missed key schema element : sort key" ?