AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
GI not returning al...
 
Notifications
Clear all

Questions GI not returning all records through SOAP API.

 
Everything Else
Last Post by Tim Rodman 5 years ago
2 Posts
2 Users
0 Reactions
2,201 Views
RSS
Tom Libby
Posts: 6
 Tom Libby
Topic starter
March 19, 2021 4:37 pm
(@tomlibby)
Active Member
Joined: 6 years ago

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
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
May 14, 2021 11:01 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hi @tomlibby,

You might want to try StackOverflow for this one:

https://stackoverflow.com/tags/acumatica


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 5 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×