Forum Discussion
Fabric GraphQl - How to create multiple record under single mutation.
Hello Anonymous
I have created a new WH called Graphql_test and created one tableMyTable andALTER TABLE MyTableADD CONSTRAINT PK_MyTable PRIMARY KEY NONCLUSTERED (ID) NOT ENFORCED;
It was empty table .
I added it to graphql api
and use muttation to add two records, it worked
Please see if this is helpful
hello Anonymous
there are two things which I want to emphasise
Primary key constraints (even `NOT ENFORCED`) are required for mutations, but these only enable single-row operations.
• Bulk operations aren’t listed as supported in Microsoft’s GraphQL API FAQ
Try this instead
mutation {
createStudent1: createStudent(item: {ROLL_NO: 1, NAME: "Ram", ...}) { result }
createStudent2: createStudent(item: {ROLL_NO: 2, NAME: "Ramesh", ...}) { result }
}
or you can explore stored proc approach for bulk inserts
something like this
CREATE PROCEDURE BulkBatchInsert
AS
BEGIN
BULK INSERT StagingStudents FROM 'data.csv' WITH (BATCHSIZE=100000);
INSERT INTO Students SELECT * FROM StagingStudents;
END;
please give it a try and let us know
thanks
Hi nilendraFabric,
Thanks for your quick respone.
I tried the above query but still unable to solve my issue. Below is the snapshot attched. Can you plz help me with this.You might have to change the syntax like this
mutation {
createempinfo1: createempinfo(item: {Id: 30, Name: "Rohan", Address: "Amravati"}) {
result
}
createempinfo2: createempinfo(item: {Id: 31, Name: "Raj", Address: "Nagpur"}) {
result
}
}can you help me in this ?