Is it possible to create a parent row (PO) wi...

(Yossi Oulu) #1

Is it possible to create a parent row (PO) with its child rows (POItems) in one web hook call? (The PO# is created with UNIQUID(), will it be written into the child rows?) I did not manage to make this work and I am wondering if it should work. Thanks

e.g. { “Action”: “Add”, “Properties”: { “Locale”: “en-US”, “Timezone”: “Israel Standard Time”

}, “Rows”: [ { “Supplier Name”: “<<[Supplier Name]>>”, “Related POItems”: { <<Start:Related POItems>>

“Rows”: [

{

“Cat#”: “<<[Cat#]>>”,

“Units”: <<[Units]>>,

“Unit Price”: <<[Price]>>,

},

] <>

} } ] }

(Philip Garrett) #2

@Yossi_Oulu

At the moment you can only add, update, or delete to a single table in each call.

You cannot add the parent record and one or more child records in the same call. You would need to make two calls. One for the parent. Another for the children.

(Yossi Oulu) #3

Yes, the problem is I do not know the parent key.as it is created with uniqueid()

(Philip Garrett) #4

@Yossi_Oulu

You are right and I don’t have a good answer. I will need to think about it and talk with others on Monday.

(Bellave Jayaram) #5

@Yossi_Oulu just wondering, can you use a time stamp and the MAX function to get the parent key for the child ?

(Praveen Seshadri (AppSheet)) #6

@Philip_Garrett_Appsh, I think we should augment the Add API call to return back the key of the created row. Let’s discuss on Monday

(Yossi Oulu) #7

Yes, this would be the cleanest solution. Thanks