RE: How can I batch invoices into customer payments using the REST API?
Hi all,
Having trouble creating/transforming invoices into customer payments using the REST API. I have no issue transforming an invoice into a customer payment like so:
POST {{REST_SERVICES}}/record/v1/invoice/4960/!transform/customerpayment
However I’d like to add multiple invoices to a customer payment in one API call, and I’m not sure how to do that. When I structure my request like this;
I get the following error:
{
“type”: “https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1”,
“title”: “Error while accessing resource: You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist.”,
“status”: 400,
“o:errorCode”: “USER_ERROR”
}
Ideally I would be able to transform multiple invoices into a customer payment…perhas by using the transformation of customer->customerpayment. But I’m not sure how to include multiple invoices that way.
Thanks!
FYI I successfully batched invoices into customer payments using 2020.2 and the following request:
{{REST_SERVICES}}/record/v1/customer/144/!transform/customerpayment
{"externalId": "PYMT-test","apply": {"items": [{"apply": true,"doc": {"id": "201"},"amount": 0.01},{"apply": true,"doc": {"id": "12"},"amount": 0.01}]}}
Thank you for posting! The doc property got me what I needed, I was frustrated trying to find the way to define the relationship between the apply prop and the actual invoices.
