cancel
Showing results for 
Search instead for 
Did you mean: 

How to Retrieve a List of Business Objects using DI Server?

Former Member
0 Kudos
545

In DI Server (and DI-API) I could not find how I can get a list of business objects, for instance ServiceCall objects.

and more - say i need the list with a filter on customer code and call status?

Accepted Solutions (1)

Accepted Solutions (1)

former_member185703
Active Contributor
0 Kudos

There's no specific API or XML for that.

You will have to run a SQL query - e.g. through DI API's Recordset object - or the DataTable in UI API - or you can apply Conditions to a DBDataSource in UI API...

HTH,

Frank

Answers (2)

Answers (2)

Former Member
0 Kudos

So there is no API - have to use SQL..

former_member185703
Active Contributor
0 Kudos

...at least not to the extent that you are looking for.

Please check the E-learning:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d78ab1f9-0901-0010-8495-8ca0faca...

at: https://www.sdn.sap.com/irj/sdn/businessone-elearning

...or go the sample code for the DataBrowser (sub-)object in the "SDK Help Center"...

...or go to the DI API sample (no. 2 I think I remember).

...to find out how you can navigate between the records of the result of your SQL query; from there you could e.g. export the objects to XML...

HTH

Gianluigi
Product and Topic Expert
Product and Topic Expert
0 Kudos

Try B1WS. It contains a service to query the DB ...

Former Member
0 Kudos

See

BoObjectTypes Enumeration in

C:\Program Files\SAP\SAP Business One SDK\Help\SDK_EN.chm

If its helps give reward points,

Regards,

Anitha

Former Member
0 Kudos

In which API or XML format should I use the BoObjectTypes Enumeration then?