I am using SOAP UI to use the B1WS/WebReferences WSDL's and was wondering if there is a way to get all orders back from it.
I am using SAP Business One and need to get all orders back as a request in that, I have found a method called getBPlist()
that gets a list of all business partners, but I want one that I can use to get all orders. Any ideas?
Asked
Active
Viewed 1,639 times
1

Sandra Rossi
- 11,934
- 5
- 22
- 48

Kieron Martin Peters
- 195
- 1
- 13
1 Answers
1
I recommend that you better use the recordset that contains the di-api, you can do the conversion as well.
SAPbobsCOM.Recordset rs = ((SAPbobsCOM.Company)oCompany.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset);
rs.DoQuery("SELECT DocEntry, DocNum, DocDate, TaxDate, CardCode, CardName, DocTotal FROM OPOR ORDER BY DocDate ASC");
while (!rs.EoF)
{
int DocEntry = rs.Fields.Item("DocEntry").Value;
//OR
DocEntry = rs.Fields.Item(0).Value;
rs.MoveNext();
}

Francisco Bernales
- 26
- 3
-
And if related data is needed like line items, order quantities, prices etc, subsequent database queries need to be done? correct? – W.M. Oct 30 '17 at 19:42