web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SBA Rest SOP API chall...
Microsoft Dynamics GP (Archived)

SBA Rest SOP API challenges

(1) ShareShare
ReportReport
Posted on by Community Member

Hi Guys,

We are using GP 2016 SBA REST API solution with Sales order processing. We are trying to do real time integration to create and update sales orders, line items. This integration has been challenging and inefficient with the number of calls that need to be made. 

For creating a sales order and adding line items, we had to perform 12 calls. This is because that some of the fields are not available during create option. For example, document dates are only available during update commands. 

We also have issues with accounts getting locked and that document dates cannot be beyond 12 months due to UK date format. 

Does anyone else have experience using SBA? What do you recommend to resolve these issues? We are also willing to pay a consultant to validate our solution design and use of SBA. 

Thank you

Phani

*This post is locked for comments

I have the same question (0)
  • mm123 Profile Picture
    mm123 2,535 on at

    Hi Phani, We have done couple of GP SBA API integration solution for our customers for Processing sales orders , If you are interested we can check this and offer the solution, Please drop an email to discuss.

    samr(at)expsoltech(dot)com

  • steveendow Profile Picture
    steveendow 2,281 on at

    Hi Phani,

    When my customers ask for a real time Dynamics GP web service integration, I recommend avoiding both SBA and GP Web Services.  I was reluctant to use GP Web Services due to its use of SOAP and limitations in its endpoints and methods, and I refuse to use SBA for an API due to its underlying architecture and significant technical limitations.

    I have instead developed custom APIs using ASP.NET, and now ASP.NET Core.  ASP.NET Core provides a fantastic, high performance, highly configurable, advanced REST interface.  Supplemental packages such as Swagger / Swashbuckle and Serilog make testing, documentation, and logging a breeze.  And unlike SBA or GP Web Services, deploying an ASP.NET Core web API only takes a few minutes.

    The ASP.NET Core web API imports transactions into GP using eConnect, and retrieves data directly via SQL.  Anything that is not supported can be created using relatively simple SQL.

    I gave a presentation on using ASP.NET Core to create a web API at the GP Tech partner conference last year, and will be presenting the session again this year.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans