Can't able to Get Customer Payment through API v2.0

(1) Share

Report

Posted on by Kanta

I can't able to find customer payment through this api :
https:/api.businesscentral.dynamics.com/v2.0/{{TeantID}}/{{env_name}}/api/v2.0/companies({{company_id}})/customerPayments

giving me value empty :
{
/@odata.context/: https:/api.businesscentral.dynamics.com/v2.0/{tenant} /{env}/api/v2.0/$metadata#companies({com-id})/customerPayments/,
/value/: []
}

But see i have 2 records there.
How can i get those 2 records using API v2.0?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

YUN ZHU 98,416 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, Try adding SystemId?

https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV2/app/src/pages/APIV2CustomerPayments.Page.al

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Kanta 20 on at

Like (2)

Report
Copy link

Link copied!

Thank you for your guide, Mr. YUN ZHU.
I actually tried putting system id in URL like this /customerPayments({systemId})
but I am getting error resource not found.
I'm not getting it, why I can't get those record, or how should I approach to get those records?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,416 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, Sorry, it looks like you are doing it right. However, Microsoft has filtered the results. The following three conditions must be met to obtain them from the standard API.

Two Examples:

https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox241/api/v2.0/companies(938320db-e10b-ef11-9f8d-6045bdacaf36)/customerPaymentJournals?$expand=customerPayments

https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox241/api/v2.0/companies(938320db-e10b-ef11-9f8d-6045bdacaf36)/customerPayments?$filter=journalId eq 587cf070-a414-ef11-9f88-000d3a50c332 and id eq f7afd139-4621-ef11-9f88-00224868ce08

PS: When taking values directly, you must add at least one filter.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Kanta 20 on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot YUN ZHU,
can you do me one more favor please.

when i'm posting cash recipt journal record my webhook give me response like this.

But as the line is posted, it got delete from customerPayments, so i can't get the relevent information about the customerPayment. i need to know which customer has paid on which invoice.
how can i get the information?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,416 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

As far as I know, it's not possible with the standard API.

There are generally two ways to do this:

1. Let the API return the results you need: As of now, the standard API is not extensible

More details: https://yzhums.com/20960/

2. Find the records in the posted table: There are two tables to look at. But neither has a standard API.

https://yzhums.com/32473/

https://yzhums.com/1335/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No