Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Logic Apps not picking up record mentioned by subscription???

(0) ShareShare
ReportReport
Posted on by 340

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:

pastedimage1679001114082v1.png

The system correctly gives me an id when the record in Business Central changes:

pastedimage1679001186411v2.png

pastedimage1679001265253v3.png

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:

pastedimage1679001369744v4.png

(That's the input) it gives me this:

pastedimage1679001447597v5.png

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:

pastedimage1679001516493v6.png

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

 

  • James McCullough Profile Picture
    340 on at
    RE: Logic Apps not picking up record mentioned by subscription???

    Sorry man, that's not even close what I reported, but thank you.

  • Nitin Verma Profile Picture
    21,544 Moderator on at
    RE: Logic Apps not picking up record mentioned by subscription???

    If you have posted the cash receipt journal, it will not be accessed. In that case you logic app can only be work if its not posted.

  • Suggested answer
    Marco Mels Profile Picture
    on at
    RE: Logic Apps not picking up record mentioned by subscription???

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    www.dynamicsuser.net/.../14

    I will open this up to the community in case they have something to add.

    Thanks.

  • James McCullough Profile Picture
    340 on at
    RE: Logic Apps not picking up record mentioned by subscription???

    No one has responded yet, but I've made a discovery.  In the case of cash receipts journals (at least) the subscription / get record combination only seems to work when it comes to posting in a cash receipt journal that was created **AFTER** the subscription has been created.  It seems that any cash receipt entered in a journal that precedes the creation of the subscription fails, but works the other way around.

    If anyone has any insight on this and could validate / verify / laugh at me, I'd appreciate it.

    Thanks!

    -J

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,135 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,871 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans