topic Re: Unable to insert,update,delete from GraphQL in Data Engineering

Unable to insert,update,delete from GraphQL

Anonymous — Fri, 31 Jan 2025 07:38:13 GMT

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 ?

Re: Unable to insert,update,delete from GraphQL

nilendraFabric — Fri, 31 Jan 2025 08:32:03 GMT

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

Re: Unable to insert,update,delete from GraphQL

Anonymous — Fri, 31 Jan 2025 09:35:53 GMT

I have used Id as primary key.

Re: Unable to insert,update,delete from GraphQL

v-csrikanth — Mon, 03 Feb 2025 12:13:13 GMT

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) {

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

Re: Unable to insert,update,delete from GraphQL

v-csrikanth — Tue, 11 Feb 2025 12:34:34 GMT

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.