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)

Suggested answer

YUN ZHU 90,204 Super User 2025 Season 2 on at

Like (1)

Report

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

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
Kanta 20 on at

Like (1)

Report

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

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
Verified answer

YUN ZHU 90,204 Super User 2025 Season 2 on at

Like (2)

Report

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

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 (2)

Report

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

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
YUN ZHU 90,204 Super User 2025 Season 2 on at

Like (2)

Report

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

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