Forum Discussion
Unable to insert,update,delete from GraphQL
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) {IdNameAddress}}******************************************************************
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
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.
Please accept this solution if this is helpful
I have used Id as primary key.