Hello
I need to expose the customer entry statistics page to webservices but I am getting an error everytime I try this. Can someone please advise how I can resolve this.
Hello
I need to expose the customer entry statistics page to webservices but I am getting an error everytime I try this. Can someone please advise how I can resolve this.
Thank you Yun Zhu,
I did do all the steps above but I get a 503 error
Hi Inge,
I did publish this page as webservices first and I do have other webservices and they all are working fine. Its just this page/card thats giving the error
Yes I did
Hi, just adding to others' reply.
This is a Card page. Even if you publish it to Web Service, the data you collect will be a little different from what you think.
For example,
{"@odata.context":"https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox214/ODataV4/$metadata#Company('My Company')/CES","value":[{"@odata.etag":"W/\"JzIwOzE1NTMwMjA5MDE4NTE4NzkzMjA4MTswMDsn\"","No":"10000","CustLedgEntry_x005B_1_x005D__Posting_Date":"2023-03-23","CustLedgEntry_x005B_2_x005D__Posting_Date":"2023-03-23","CustLedgEntry_x005B_3_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_5_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_4_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_6_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_1_x005D__Document_No":"103191","CustLedgEntry_x005B_2_x005D__Document_No":"103191","CustLedgEntry_x005B_3_x005D__Document_No":"","CustLedgEntry_x005B_5_x005D__Document_No":"","CustLedgEntry_x005B_4_x005D__Document_No":"","CustLedgEntry_x005B_6_x005D__Document_No":"","CustLedgEntry_x005B_1_x005D__Currency_Code":"","CustLedgEntry_x005B_2_x005D__Currency_Code":"","CustLedgEntry_x005B_3_x005D__Currency_Code":"","CustLedgEntry_x005B_5_x005D__Currency_Code":"","CustLedgEntry_x005B_4_x005D__Currency_Code":"","CustLedgEntry_x005B_6_x005D__Currency_Code":"","_CustLedgEntry_x005B_1_x005D__Amount":16513.5,"CustLedgEntry_x005B_2_x005D__Amount":16513.5,"_CustLedgEntry_x005B_3_x005D__Amount":0,"CustLedgEntry_x005B_5_x005D__Amount":0,"CustLedgEntry_x005B_4_x005D__Amount":0,"CustLedgEntry_x005B_6_x005D__Amount":0,"_CustLedgEntry_x005B_1_x005D__Remaining_Amount":0,"RemainingAmount":0,"_CustLedgEntry_x005B_3_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_5_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_4_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_6_x005D__Remaining_Amount":0,"CustDateName_x005B_1_x005D_":"February ","NoOfDoc_x005B_1_x005D__x005B_1_x005D_":4,"NoOfDoc_x005B_1_x005D__x005B_2_x005D_":4,"NoOfDoc_x005B_1_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisPeriod":15.25,"HighestBalanceLCY_x005B_1_x005D_":20952.01,"Text000":"Placeholder","NoOfDoc_x005B_2_x005D__x005B_1_x005D_":12,"NoOfDoc_x005B_2_x005D__x005B_2_x005D_":12,"NoOfDoc_x005B_2_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisYear":17.9166666666666667,"HighestBalanceLCY_x005B_2_x005D_":20952.01,"Placeholder2":"Placeholder","NoOfDoc_x005B_3_x005D__x005B_1_x005D_":21,"NoOfDoc_x005B_3_x005D__x005B_2_x005D_":21,"NoOfDoc_x005B_3_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_LastYear":0,"HighestBalanceLCY_x005B_3_x005D_":16162.00,"Placeholder3":"Placeholder","_TotalRemainAmountLCY_x005B_1_x005D_":0,"TotalRemainAmountLCY_x005B_2_x005D_":0,"_TotalRemainAmountLCY_x005B_3_x005D_":0,"TotalRemainAmountLCY_x005B_5_x005D_":0,"TotalRemainAmountLCY_x005B_4_x005D_":0,"TotalRemainAmountLCY_x005B_6_x005D_":0,"Placeholder4":"Placeholder","Placeholder5":"Placeholder"},{"@odata.etag":"W/\"JzE3OzcxNDU2MzU0MDc5MjY0Mjg4MTswMDsn\"","No":"20000","CustLedgEntry_x005B_1_x005D__Posting_Date":"2023-04-10","CustLedgEntry_x005B_2_x005D__Posting_Date":"2023-03-28","CustLedgEntry_x005B_3_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_5_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_4_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_6_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_1_x005D__Document_No":"103205","CustLedgEntry_x005B_2_x005D__Document_No":"103195","CustLedgEntry_x005B_3_x005D__Document_No":"","CustLedgEntry_x005B_5_x005D__Document_No":"","CustLedgEntry_x005B_4_x005D__Document_No":"","CustLedgEntry_x005B_6_x005D__Document_No":"","CustLedgEntry_x005B_1_x005D__Currency_Code":"","CustLedgEntry_x005B_2_x005D__Currency_Code":"","CustLedgEntry_x005B_3_x005D__Currency_Code":"","CustLedgEntry_x005B_5_x005D__Currency_Code":"","CustLedgEntry_x005B_4_x005D__Currency_Code":"","CustLedgEntry_x005B_6_x005D__Currency_Code":"","_CustLedgEntry_x005B_1_x005D__Amount":554.5,"CustLedgEntry_x005B_2_x005D__Amount":781.88,"_CustLedgEntry_x005B_3_x005D__Amount":0,"CustLedgEntry_x005B_5_x005D__Amount":0,"CustLedgEntry_x005B_4_x005D__Amount":0,"CustLedgEntry_x005B_6_x005D__Amount":0,"_CustLedgEntry_x005B_1_x005D__Remaining_Amount":0,"RemainingAmount":781.88,"_CustLedgEntry_x005B_3_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_5_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_4_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_6_x005D__Remaining_Amount":0,"CustDateName_x005B_1_x005D_":"February ","NoOfDoc_x005B_1_x005D__x005B_1_x005D_":5,"NoOfDoc_x005B_1_x005D__x005B_2_x005D_":6,"NoOfDoc_x005B_1_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisPeriod":13.2,"HighestBalanceLCY_x005B_1_x005D_":8179.00,"Text000":"Placeholder","NoOfDoc_x005B_2_x005D__x005B_1_x005D_":12,"NoOfDoc_x005B_2_x005D__x005B_2_x005D_":15,"NoOfDoc_x005B_2_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisYear":14.8333333333333333,"HighestBalanceLCY_x005B_2_x005D_":8179.00,"Placeholder2":"Placeholder","NoOfDoc_x005B_3_x005D__x005B_1_x005D_":36,"NoOfDoc_x005B_3_x005D__x005B_2_x005D_":36,"NoOfDoc_x005B_3_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_LastYear":0,"HighestBalanceLCY_x005B_3_x005D_":2490.75,"Placeholder3":"Placeholder","_TotalRemainAmountLCY_x005B_1_x005D_":0,"TotalRemainAmountLCY_x005B_2_x005D_":2345.63,"_TotalRemainAmountLCY_x005B_3_x005D_":0,"TotalRemainAmountLCY_x005B_5_x005D_":0,"TotalRemainAmountLCY_x005B_4_x005D_":0,"TotalRemainAmountLCY_x005B_6_x005D_":0,"Placeholder4":"Placeholder","Placeholder5":"Placeholder"},{"@odata.etag":"W/\"JzIwOzE2NTI1NTEzMzQxMTAxMTk2MjEwMTswMDsn\"","No":"30000","CustLedgEntry_x005B_1_x005D__Posting_Date":"2023-03-26","CustLedgEntry_x005B_2_x005D__Posting_Date":"2023-04-01","CustLedgEntry_x005B_3_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_5_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_4_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_6_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_1_x005D__Document_No":"103193","CustLedgEntry_x005B_2_x005D__Document_No":"103198","CustLedgEntry_x005B_3_x005D__Document_No":"","CustLedgEntry_x005B_5_x005D__Document_No":"","CustLedgEntry_x005B_4_x005D__Document_No":"","CustLedgEntry_x005B_6_x005D__Document_No":"","CustLedgEntry_x005B_1_x005D__Currency_Code":"","CustLedgEntry_x005B_2_x005D__Currency_Code":"","CustLedgEntry_x005B_3_x005D__Currency_Code":"","CustLedgEntry_x005B_5_x005D__Currency_Code":"","CustLedgEntry_x005B_4_x005D__Currency_Code":"","CustLedgEntry_x005B_6_x005D__Currency_Code":"","_CustLedgEntry_x005B_1_x005D__Amount":427.2,"CustLedgEntry_x005B_2_x005D__Amount":1236.6,"_CustLedgEntry_x005B_3_x005D__Amount":0,"CustLedgEntry_x005B_5_x005D__Amount":0,"CustLedgEntry_x005B_4_x005D__Amount":0,"CustLedgEntry_x005B_6_x005D__Amount":0,"_CustLedgEntry_x005B_1_x005D__Remaining_Amount":0,"RemainingAmount":1236.6,"_CustLedgEntry_x005B_3_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_5_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_4_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_6_x005D__Remaining_Amount":0,"CustDateName_x005B_1_x005D_":"February ","NoOfDoc_x005B_1_x005D__x005B_1_x005D_":3,"NoOfDoc_x005B_1_x005D__x005B_2_x005D_":4,"NoOfDoc_x005B_1_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisPeriod":0,"HighestBalanceLCY_x005B_1_x005D_":19312.9,"Text000":"Placeholder","NoOfDoc_x005B_2_x005D__x005B_1_x005D_":8,"NoOfDoc_x005B_2_x005D__x005B_2_x005D_":14,"NoOfDoc_x005B_2_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisYear":4.25,"HighestBalanceLCY_x005B_2_x005D_":32644.3,"Placeholder2":"Placeholder","NoOfDoc_x005B_3_x005D__x005B_1_x005D_":45,"NoOfDoc_x005B_3_x005D__x005B_2_x005D_":45,"NoOfDoc_x005B_3_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_LastYear":0,"HighestBalanceLCY_x005B_3_x005D_":10163.4,"Placeholder3":"Placeholder","_TotalRemainAmountLCY_x005B_1_x005D_":0,"TotalRemainAmountLCY_x005B_2_x005D_":32644.3,"_TotalRemainAmountLCY_x005B_3_x005D_":0,"TotalRemainAmountLCY_x005B_5_x005D_":0,"TotalRemainAmountLCY_x005B_4_x005D_":0,"TotalRemainAmountLCY_x005B_6_x005D_":0,"Placeholder4":"Placeholder","Placeholder5":"Placeholder"},{"@odata.etag":"W/\"JzIwOzE1OTEzNzAxMTcwMTE1NDk1MDgwMTswMDsn\"","No":"40000","CustLedgEntry_x005B_1_x005D__Posting_Date":"2023-03-26","CustLedgEntry_x005B_2_x005D__Posting_Date":"2023-03-26","CustLedgEntry_x005B_3_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_5_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_4_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_6_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_1_x005D__Document_No":"103194","CustLedgEntry_x005B_2_x005D__Document_No":"103194","CustLedgEntry_x005B_3_x005D__Document_No":"","CustLedgEntry_x005B_5_x005D__Document_No":"","CustLedgEntry_x005B_4_x005D__Document_No":"","CustLedgEntry_x005B_6_x005D__Document_No":"","CustLedgEntry_x005B_1_x005D__Currency_Code":"","CustLedgEntry_x005B_2_x005D__Currency_Code":"","CustLedgEntry_x005B_3_x005D__Currency_Code":"","CustLedgEntry_x005B_5_x005D__Currency_Code":"","CustLedgEntry_x005B_4_x005D__Currency_Code":"","CustLedgEntry_x005B_6_x005D__Currency_Code":"","_CustLedgEntry_x005B_1_x005D__Amount":2987.4,"CustLedgEntry_x005B_2_x005D__Amount":2987.4,"_CustLedgEntry_x005B_3_x005D__Amount":0,"CustLedgEntry_x005B_5_x005D__Amount":0,"CustLedgEntry_x005B_4_x005D__Amount":0,"CustLedgEntry_x005B_6_x005D__Amount":0,"_CustLedgEntry_x005B_1_x005D__Remaining_Amount":0,"RemainingAmount":0,"_CustLedgEntry_x005B_3_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_5_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_4_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_6_x005D__Remaining_Amount":0,"CustDateName_x005B_1_x005D_":"February ","NoOfDoc_x005B_1_x005D__x005B_1_x005D_":1,"NoOfDoc_x005B_1_x005D__x005B_2_x005D_":2,"NoOfDoc_x005B_1_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisPeriod":0,"HighestBalanceLCY_x005B_1_x005D_":5954.9,"Text000":"Placeholder","NoOfDoc_x005B_2_x005D__x005B_1_x005D_":7,"NoOfDoc_x005B_2_x005D__x005B_2_x005D_":8,"NoOfDoc_x005B_2_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisYear":11.4285714285714286,"HighestBalanceLCY_x005B_2_x005D_":5954.9,"Placeholder2":"Placeholder","NoOfDoc_x005B_3_x005D__x005B_1_x005D_":20,"NoOfDoc_x005B_3_x005D__x005B_2_x005D_":20,"NoOfDoc_x005B_3_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_LastYear":0,"HighestBalanceLCY_x005B_3_x005D_":3284.5,"Placeholder3":"Placeholder","_TotalRemainAmountLCY_x005B_1_x005D_":0,"TotalRemainAmountLCY_x005B_2_x005D_":2617.5,"_TotalRemainAmountLCY_x005B_3_x005D_":0,"TotalRemainAmountLCY_x005B_5_x005D_":0,"TotalRemainAmountLCY_x005B_4_x005D_":0,"TotalRemainAmountLCY_x005B_6_x005D_":0,"Placeholder4":"Placeholder","Placeholder5":"Placeholder"},{"@odata.etag":"W/\"JzIwOzE3NDU4MzI0NzM5ODY2NzQ2NTk5MTswMDsn\"","No":"50000","CustLedgEntry_x005B_1_x005D__Posting_Date":"2023-03-25","CustLedgEntry_x005B_2_x005D__Posting_Date":"2023-03-31","CustLedgEntry_x005B_3_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_5_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_4_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_6_x005D__Posting_Date":"0001-01-01","CustLedgEntry_x005B_1_x005D__Document_No":"103192","CustLedgEntry_x005B_2_x005D__Document_No":"103197","CustLedgEntry_x005B_3_x005D__Document_No":"","CustLedgEntry_x005B_5_x005D__Document_No":"","CustLedgEntry_x005B_4_x005D__Document_No":"","CustLedgEntry_x005B_6_x005D__Document_No":"","CustLedgEntry_x005B_1_x005D__Currency_Code":"","CustLedgEntry_x005B_2_x005D__Currency_Code":"","CustLedgEntry_x005B_3_x005D__Currency_Code":"","CustLedgEntry_x005B_5_x005D__Currency_Code":"","CustLedgEntry_x005B_4_x005D__Currency_Code":"","CustLedgEntry_x005B_6_x005D__Currency_Code":"","_CustLedgEntry_x005B_1_x005D__Amount":3517.5,"CustLedgEntry_x005B_2_x005D__Amount":2358.38,"_CustLedgEntry_x005B_3_x005D__Amount":0,"CustLedgEntry_x005B_5_x005D__Amount":0,"CustLedgEntry_x005B_4_x005D__Amount":0,"CustLedgEntry_x005B_6_x005D__Amount":0,"_CustLedgEntry_x005B_1_x005D__Remaining_Amount":0,"RemainingAmount":2358.38,"_CustLedgEntry_x005B_3_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_5_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_4_x005D__Remaining_Amount":0,"CustLedgEntry_x005B_6_x005D__Remaining_Amount":0,"CustDateName_x005B_1_x005D_":"February ","NoOfDoc_x005B_1_x005D__x005B_1_x005D_":1,"NoOfDoc_x005B_1_x005D__x005B_2_x005D_":2,"NoOfDoc_x005B_1_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_1_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisPeriod":0,"HighestBalanceLCY_x005B_1_x005D_":6027.75,"Text000":"Placeholder","NoOfDoc_x005B_2_x005D__x005B_1_x005D_":5,"NoOfDoc_x005B_2_x005D__x005B_2_x005D_":8,"NoOfDoc_x005B_2_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_2_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_ThisYear":0,"HighestBalanceLCY_x005B_2_x005D_":7921.50,"Placeholder2":"Placeholder","NoOfDoc_x005B_3_x005D__x005B_1_x005D_":35,"NoOfDoc_x005B_3_x005D__x005B_2_x005D_":35,"NoOfDoc_x005B_3_x005D__x005B_3_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_5_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_4_x005D_":0,"NoOfDoc_x005B_3_x005D__x005B_6_x005D_":0,"AvgCollectionPeriodDays_LastYear":0,"HighestBalanceLCY_x005B_3_x005D_":3517.50,"Placeholder3":"Placeholder","_TotalRemainAmountLCY_x005B_1_x005D_":0,"TotalRemainAmountLCY_x005B_2_x005D_":6762.38,"_TotalRemainAmountLCY_x005B_3_x005D_":0,"TotalRemainAmountLCY_x005B_5_x005D_":0,"TotalRemainAmountLCY_x005B_4_x005D_":0,"TotalRemainAmountLCY_x005B_6_x005D_":0,"Placeholder4":"Placeholder","Placeholder5":"Placeholder"}]}
Hope this helps.
Thanks.
ZHU
The page needs to be published as a webservice first.
And do you have other webservices in your installation that are working?
Did you publish the page in Web Services page first?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,556 Super User 2024 Season 2
Martin Dráb 228,625 Most Valuable Professional
nmaenpaa 101,148