Any idea how to reference an item when transformin...
# suitetalkapik
Kyle Rainier
03/22/2023, 8:14 PMAny idea how to reference an item when transforming from purchaseorder>vendorbill? I've tried:
Copy code
{
"method": "POST",
"url": "<https://3997092-sb1.suitetalk.api.netsuite.com/services/rest/record/v1/purchaseorder/2201922/!transform/vendorbill>",
"headers": {...},
"body": {
"tranid": "I-058298",
"item": {
"items": [
{
"item": "37624",
"rate": 11,
"quantity": 1
}
]
}
}
} Copy code
{
"method": "POST",
"url": "<https://3997092-sb1.suitetalk.api.netsuite.com/services/rest/record/v1/purchaseorder/2201922/!transform/vendorbill>",
"headers": {...},
"body": {
"tranid": "I-058298",
"item": {
"items": [
{
"item": {"id": "37624"},
"rate": 11,
"quantity": 1
}
]
}
}
}Kyle Rainier
03/22/2023, 8:14 PMI've tried many variations and only get:
Copy code
{
"detail": "Error while accessing a resource. Please choose an item to add.",
"o:errorPath": "item.items[0]",
"o:errorCode": "USER_ERROR"
}b
battk
03/22/2023, 9:01 PMk
Kyle Rainier
03/22/2023, 9:05 PMsetting the replace parameter gives me a 500 error
b
battk
03/22/2023, 9:08 PMcontinue through the information about keys
k
Kyle Rainier
03/22/2023, 9:16 PMKey1, key2 is a little abstract. Do I need item id and line number or something?
b
battk
03/22/2023, 9:17 PMitem id is not unique
battk
03/22/2023, 9:17 PMit cant be the key
battk
03/22/2023, 9:18 PMline number isnt really great either, that can change
k
Kyle Rainier
03/22/2023, 9:18 PMIf I look at a PO, it has lineuniquekey
Kyle Rainier
03/22/2023, 9:18 PMalong with a line id
b
battk
03/22/2023, 9:18 PMworking with sublists generally involves guessing the key
battk
03/22/2023, 9:19 PMa lot of the time its the same as soap keys
k
Kyle Rainier
03/22/2023, 9:24 PMany idea why ?replace=item would throw a 500? The documentation on !transform says to use POST, so I don't think it will support PATCH
Kyle Rainier
03/22/2023, 9:24 PMlineuniquekey gives the same "item not found" if I remove the replace flag
Kyle Rainier
03/22/2023, 9:27 PMinternalId and line give the same result
b
battk
03/22/2023, 9:44 PMthere is no point doing a transform if you are replacing all the items
battk
03/22/2023, 10:10 PMwhat is the key for soap
k
Kyle Rainier
03/23/2023, 1:53 AMI'm partially billed for purchase orders as they are fulfilled.
Kyle Rainier
03/23/2023, 1:53 AMThe key for soap seems to be orderLine or line, neither of these work
Kyle Rainier
03/23/2023, 1:55 AMAdding order line gives me a 500
b
battk
03/23/2023, 2:23 AMyou may just want to manually create the vendorbill without transforming
battk
03/23/2023, 2:24 AMyou should hopefully be able to link the two by setting the orderLine and orderDoc fields on the item
battk
03/23/2023, 2:25 AMelse you need to go into the body of the response for those failures, the status code by itself isnt very helpful
k
Kyle Rainier
03/23/2023, 2:14 PMOk, I may pursue this as a work around and file a support ticket to see if they can clarify billing in the transform step. At scale, one step would be better. Thanks for all you help!
6 Views