on 03-28-2017 1:31 PM
Hi,
I am using $batch option to insert the multiple records into multiple tables (like Header and Item).I am running the service from POSTMAN client,the status is showing as 202 but no entries created in tables and not triggering in debug mode from postman client.
Can you please help and suggest how we can proceed.
Find the attachment for $batch payload.
Here is the requirement:
I need your suggestion on the below requirement.
We have three tables with common key ‘PURCHASEORDERID’, created association between these three and we will get the data (Header, Item and ItmMat) from UI at one shot (submit the data in one payload).
Now that data need to be process and insert into respective tables (we will have multiple records in Item and ItmMat). Can you please suggest how to proceed? and share any example if you have.
Tables:
"workshop.exercises.g001::PurchaseOrder.Header"
"workshop.exercises.g001::PurchaseOrder.Item"
"workshop.exercises.g001::PurchaseOrder.ItmMat"
Example:
Header-
PURCHASEORDERID HISTORY.CREATEDBY CURRENCY GROSSAMOUNT NETAMOUNT TAXAMOUNT 300000001 USHI EUR 345 231 23 300000002 USHI EUR 678 525 45
Item-
PURCHASEORDERID PURCHASEORDERITEM QUANTITY PRODUCT CURRENCY GROSSAMOUNT NETAMOUNT TAXAMOUNT 300000001 10 2 EUR 567 231 23 300000002 20 5 EUR 987 525 45
ItmMat-
PURCHASEORDERID ITEM MATERIAL QUANTITY PRODUCT CURRENCY GROSSAMOUNT NETAMOUNT TAXAMOUNT 300000001 10 9076521 4 EUR 567 231 23 300000002 20 9076523 3 EUR 987 525 45
Thanks,batch-postman.txt
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.