Business Central API SOAP field listing is different from the oData field listing

(0) Share

Report

Posted on by Community Member

Hello,

We are integrating our web based procurment product with Business Central and using the web services to export data via SOAP.

When setting up the following Web Service

ObjectType = "Page"

Table = 537

Object Name = Dimension Values

If you click on the SOAP URL that is generated it gives your the xml output, which has a FieldListing. You will see that the field [Dimension_Code] is missing, which should be incorrect, because this field is a Primary Key field in the [Dimension Value] table within BC.

On the same web service setup, if you click on the oData URI, the output from OData does list the [Dimension_Code] has a valid field.

With the same Web service, how are the two outputs different?

With the SOAP, with this web service, you cannot use, because you cannot pass in one of the required fields.

Thank you in advance for any help!

Heather Scovell

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: Business Central API SOAP field listing is different from the oData field listing

Thank you! That is helpful!
Verified answer

keoma 32,727 on at

Like (0)

Report

RE: Business Central API SOAP field listing is different from the oData field listing

the soap call, using a page, simply shows only the fields, which are shown in the page. page 537 shows not field dimension code per default. if you set that field (programmatically) to visible in the page, it will also be shown in the soap result. odata works differents, shows the table fields.