Small and medium business | Business Central, N...

Odata 404 error

(0) Share

Report

Posted on by drew777777

138

I have exposed the Sales Invoice Statistics page (Object ID 10041) as an Odata web service.

When I attempt to query the URL for the service in Power BI and other applications, I receive a 404 error.

Below is the response I receive.

{
"error": {
"code": "Internal_RecordNotFound",
"message": "The Tax Area does not exist. Identification fields and values: Code=''"
}
}

I have exposed many other pages as Odata web services and have not had issues.

Looking for advice on how to go about fixing this issue.

I need to query the Sales Invoice Statistics page for some Power BI reporting.

All responses (3)

Answers (0)

drew777777 138 on at

Like (0)

Report

RE: Odata 404 error

Thanks. I have learned that Page 10041 is not compatible with Odata Web Services. When attempting to open the same page in NAV 18 CRONUS, I run into the same issue.

I'm still confused by the error message and why it is referencing the "Tax Area". I cannot locate a Tax Area field on Page 10041. I will query a different page for my Power BI report.

{

"error": {

"code": "Internal_RecordNotFound",

"message": "The Tax Area does not exist. Identification fields and values: Code=''"

}

}
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: Odata 404 error

Hi, you can try to open the Sales Invoice Statistics page (Object ID 10041) directly in the development environment. As far as I know, this page must be opened from the Sales Invoice page, and there is no data when it is opened directly.

So unfortunately, this page cannot be used in Power BI, you need to develop another page.

Hopefully other experts can give you better advice.

Thanks.

ZHU
Suggested answer

Manan_Shah 1,457 on at

Like (0)

Report

RE: Odata 404 error

Hi,

I am not too sure where you can create a webservice page for Sales Invoice Statistics as I think it's temporary data page. And each time of open it will calculate date.

Also as per error message i think on Invoice header it's not have Tax Area code value. You can fill it on Customer card and it will flow to Sales Invoice Header.

Put filter on Invoice list page. for Tax Area code which document have value of Tax Area try to check your web service with that document.

Hope this will help.

Many Thanks,
Manan