By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Everything Else
2
Posts
2
Users
0
Reactions
2,201
Views
March 19, 2021 4:37 pm
I have a very simple GI based on a custom table in Acuamtica, basically just a data dump. I am accessing through the SOAP API.
When I run the GI in Acumatica it returns multiple, the multiple records are identical. When I access this GI through the SOAP API for each set of multiple records, I only get 1. I cannot just use the 1 record since there is a quantity field that I need to determine the total quantity for the set of records.
I created the web service based on https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/
Any reason why this would only return the 1 record and not multiple?
We are on version 2019 R1 Build 19.104.0024.
BBDropShipAPI bBDropShipAPI = new BBDropShipAPI()
{
Result = new BBDropShipResult[]
{
new BBDropShipResult
{
OrderNbr = new StringReturn(),
InventoryID = new StringReturn(),
DSOrderQty = new DecimalReturn(),
//OrderNbr = new StringSearch {
// Condition = StringCondition.Equal,
// Value = orderNumber
//},
ReturnBehavior = ReturnBehavior.OnlySpecified
}
}
};
bBDropShipAPI = (BBDropShipAPI)soapClient.Get(bBDropShipAPI);
TextLogger log = new TextLogger($"c:\\temp\\dsexport2{DateTime.Now.ToString("yyyyMMddmmss")}.csv");
foreach (BBDropShipResult bbdsr in bBDropShipAPI.Result)
{
log.Log($"{bbdsr.OrderNbr.Value},{ bbdsr.InventoryID.Value},{ bbdsr.DSOrderQty.Value}",false);
}
1 Reply
May 14, 2021 11:01 pm
Hi @tomlibby,
You might want to try StackOverflow for this one:
https://stackoverflow.com/tags/acumatica
