Answered

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:

Integration with Dynamics 365 products

Sales

Financial Management

Development

All responses (5)

Answers (1)

Suggested answer

YUN ZHU 63,463 Super User 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
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?
Verified answer

YUN ZHU 63,463 Super User 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
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?
YUN ZHU 63,463 Super User 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