Unable to insert,update,delete from GraphQL

[Anonymous]

I am using Graph Ql, I performing the different CRUD operation. When I am doing single update,insert and delete its working. But when I am trying with multiple rows I am not able to do. Did any one tried it ?

[v-csrikanth]

Hi @Anonymous 
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please accept as solution to help others benefit.
Thank you.

[v-csrikanth · Accepted solution]

Hi @Anonymous 
Thank you for being part of the Microsoft Fabric Community.
If your fabric graphql api allows array-based inserts, you can modify the mutation to accept multiple records:

****************************************************************

mutation CreateEmployees($items: [EmpInput!]!) {

  createempinfo(items: $items) {

    Id

    Name

    Address

  }

}

******************************************************************

JSON

******************************************************************

{
"query": "mutation CreateEmployees($items: [EmpInput!]!) { createempinfo(items: $items) { Id Name Address } }",
"variables": {
"items": [
{"Address": "Pune", "Id": 1000, "Name": "Then"},
{"Address": "Paratwada", "Id": 1001, "Name": "Chetan"}
]
}
}

******************************************************************

If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.

Thanks,
Cheri Srikanth

[nilendraFabric]

Hello @Anonymous 

You cannot use the automatically generated GraphQL mutations in Microsoft Fabric to perform inserts, updates, or deletes on multiple rows in a single call because each of those mutations requires a primary key value for one specific row.

https://www.mssqltips.com/sqlservertip/8113/crud-operations-in-microsoft-fabric-using-graphql-api-mutations

Please accept this solution if this is helpful 

[Anonymous]

I have used Id as primary key.