How to access index(GSI) with amplify API?

[Frankat1578]

Hi, Is the a way I can query data with index, both Partition and Sort keys, using the GraphQL API in android? I have already pulled down the index into my local project and its inside my query schema. Also I am able to query and generate results in my AppSyncConsole. But am unable to use this inside my android project? Using the example below is the any way I can use the index in the android project query?

  id: ID!
  name: String! @index(name: "byNameAndPhoneNumber", sortKeyFields: ["phoneNumber"], queryField: "customerByNameAndPhone")
  phoneNumber: String
  accountRepresentativeID: ID! @index 

Any links or suggestion is welcome. Thanks

[AnilMaktala]

Hi @Frankat1578 👋 , Thank you for the question. can you please share the query you tried in AppSync console?

[Frankat1578]

Hi @AnilMaktala, This is my index definition: id: ID! @index(name: "byEventTime", sortKeyFields:["EventTime"])

Below is the simple query I tried in AppSync .

query MyQueryEvent {
  eventByIdAndEventTime(id: "a6b8a147-cb02-4f14-8157-a8e75d6cce82", EventTime: {eq: "05:15"}) {
    nextToken
    startedAt
    items {
      EventName
      EventTime
      EventStatus
    }
  }
}

[vsvinayak]

@Frankat1578, were you able to find a solution ? I am also facing a similar situation.

[mindgrub-medwards]

I'm also looking for a solution to this...