Hi Connections
I'm attempting to use an API to update vendor info like primary contacts and account addresses. Except for the vendor name, the application's other data fields are not updated. Please use the payload shown below as a guide.
{
"VendorID": {
"value": "V00001"
},
"VendorName": {
"value": "SSCI Energy Sdn Bhd"
},
"Name": {
"value": "Robert"
},
"Email": {
"value": "robert@sscienergy.com.my"
}
}
Thanks
Ram
Best answer by Vignesh Ponnusamy
Primary contact and account address are a part of the default endpoint. Below are the details,
Below is the screenshot and marking of the entities and few contact fields for your reference,
So to expand these entities, you can try the following,
<<Acumatica URL>>/entity/Default/22.200.001/Vendor?$filter=VendorID eq 'AASERVICES'&$expand=PrimaryContact,MainContact/Address
To add/update values to their field you can try the following payload structure,
{
"VendorID": {
"value": "AASERVICES"
},
"MainContact": {
"Address": {
"AddressLine1": {
"value": "Line 1"
},
"AddressLine2": {
"value": "Line 2"
},
"City": {
"value": "Montreal"
},
"Country": {
"value": "US"
},
"PostalCode": {
"value": "30042"
},
"State": {
"value": "GA"
}
}
},
"PrimaryContact": {
"FirstName": {
"value": "FirstName"
},
"LastName": {
"value": "LastName"
},
"Email": {
"value": "EMailTest@test.com"
},
"Phone1Type": {
"value": "Business 1"
},
"Phone1": {
"value": "789"
},
"Phone2Type": {
"value": "Business 1"
},
"Phone2": {
"value": "123"
}
}
}Hope that helps.!
Good Luck, feel free to post if you have follow-up questions
+15You should look at the endpoint for Vendors (SM207060) as that will give you some pointers but to keep it simple your are trying to update the Contact Details with the name/email. This is nested under the vendor so we must call it by name MainContact and then use [ ] to enclose the details.
I may have a type in here as not tested it.
{
"VendorID": {"value": "V00001"},
"VendorName": {"value": "SSCI Energy Sdn Bhd"},
“MainContact”:
[
{
"Name": { "value": "Robert"},
"Email": {"value": "robert@sscienergy.com.my"}
}
]
}
Hi
I’m getting the below error while include the Maincontact.
{
"message": "The request is invalid.",
"modelState": {
"": [
"Error reading JObject from JsonReader. Current JsonReader item is not an object: StartArray. Path 'MainContact', line 9, position 9."
]
}
}
My payload below
{
"VendorID": {
"value": "V00001"
},
"VendorName": {
"value": "SSCI Energy Sdn Bhd"
},
"MainContact":
[
{
"Name": {
"value": "Riayah"
},
"Email": {
"value": "riayaht@sscienergy.com.my"
}
}
]
}
+15Apologies sorry I have the Sales Order in my head, i think the easiest way to do it is extend the existing end point and then use the Extend Entity to then add the two fields you are after (see below). You should then be able to post it it using your existing put just to your new endpoint.
+5Primary contact and account address are a part of the default endpoint. Below are the details,
Below is the screenshot and marking of the entities and few contact fields for your reference,
So to expand these entities, you can try the following,
<<Acumatica URL>>/entity/Default/22.200.001/Vendor?$filter=VendorID eq 'AASERVICES'&$expand=PrimaryContact,MainContact/Address
To add/update values to their field you can try the following payload structure,
{
"VendorID": {
"value": "AASERVICES"
},
"MainContact": {
"Address": {
"AddressLine1": {
"value": "Line 1"
},
"AddressLine2": {
"value": "Line 2"
},
"City": {
"value": "Montreal"
},
"Country": {
"value": "US"
},
"PostalCode": {
"value": "30042"
},
"State": {
"value": "GA"
}
}
},
"PrimaryContact": {
"FirstName": {
"value": "FirstName"
},
"LastName": {
"value": "LastName"
},
"Email": {
"value": "EMailTest@test.com"
},
"Phone1Type": {
"value": "Business 1"
},
"Phone1": {
"value": "789"
},
"Phone2Type": {
"value": "Business 1"
},
"Phone2": {
"value": "123"
}
}
}Hope that helps.!
Good Luck, feel free to post if you have follow-up questions
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.