Hey Everyone:
I have a need to execute a logic app when a customer payment record is changed in Business Central. This pattern that I describe here works for other records. It does not work for customer payments, however, and I was hoping someone could either point me in the right direction, or validate that I'm not crazy?
The proposal is simple - here is the logic app:
The system correctly gives me an id when the record in Business Central changes:
So far so good. This is the record that the system just alerted me changed, as verified by the system ID in the webhook and the system ID on the screen. But when I try to get that record:
(That's the input) it gives me this:
And bombs right out. It cannot find the record, it seems. Being a (somewhat) smart man, I decided to run this through Postman, too. And I get:
This is by calling:
api.businesscentral.dynamics.com/.../{{TenantID}}/sandbox/api/v2.0/companies({{CompanyID}})/customerPayments(7e094726-36c4-ed11-9a88-002248b18ec2)
So, seemingly, what I'm faced with here is:
- record x is changed
- the webhook is updated and notifies the logic app
- the logic app initiates, takes the row number
- record x doesn't appear to exist in the same table that called it
Am I nuts? Did I do something wrong? Why on earth would this work for one type of document and not another, especially when I can clearly see the system ID on the screen? Thoughts? Advice? Bueller?
Thanks.
-J
