Course Description

By completing the Advanced Data Retrieval course, you will be familiar with the advanced techniques of data retrieval through the Acumatica ERP web services APIs.

This course shows advanced techniques of the data retrieval with the contract-based REST and SOAP APIs. One of the data retrieval scenarios is implemented with the screen-based SOAP API. The course is based on a set of examples of web integration scenarios that demonstrate the processes involved in developing a client application that uses Acumatica ERP integration interfaces. The course gives you ideas about how to develop your own applications by using the web services APIs. As you go through the course, you can complete the examples for a particular integration interface or for multiple integration interfaces.

You can download or clone the Help-and-Training-Examples repository from GitHub and find the examples of this course in the IntegrationDevelopment/I310 folder of the repository.

What's new in this course ?

The course has been updated as follows:

The guide has been updated to reflect 2019 R2 version of Acumatica ERP.
Lesson 2.2: Retrieving a List of Sales Orders in Batches has been added, which shows how to retrieve records from Acumatica ERP in batches of multiple records.
Part 1: Authorization of the Application to Work with the Web Service has been updated with the information about the support of the OAuth 2.0 authorization for the OData interface.
Lesson 2.1: Retrieving a List of Sales Orders with Details and Related Shipments has been updated to show the best approach to obtain records with multiple kinds of detail lines.
Minor corrections, improvements and updates have been made throughout the guide.
The training examples have been updated and published on GitHub.

Training Materials

I310 TRAINING GUIDE

Installations

Site Feedback

Training Recordings

Session One

Session Two

Session One

Session Two

Here is the link to Postman collections used in the OData session: link

Additional Reference

Resource Owner Password Credentials Flow

Parameters for Retrieving Records

ReturnBehavior Property (Contract Version 3)

Retrieval of a File Attached to a Record

GetFiles() Method

Related Courses

Testimonials

The class was very informative and well laid out to teach the module.

Heath H.

Project Billing and Change Management

It was really nice seeing what a fully built and functional Project management system could do for us.

Thomas S.

Project Billing and Change Management

I liked that the examples were written in the guide, explained and shown.

Megan H.

Accounting for Projects

I am very excited about the EU training! The SweetLife instance and manuals seem wonderful so far.

Kimberly W.

Sales and Purchases

The material and guide were great.

Wendy P.

Basic System Configuration

Training Guide was well laid out with clear, easy steps to follow.

Jason M.

System Management and Self-Service Portal

It was an excellent experience. I am very satisfied with this course.

Alfred M.

S130 Data Retrieval and Analysis

The most effective part about the session was the practical examples and not just repeating what was written in the guide. So the real life examples were very helpful.

Marilize Z.

S130 Data Retrieval and Analysis

It is a well written fundamental course.

Kathryn W.

D200 Order and Inventory Management: Intermediate

Easy to follow and understand the way the course is laid out. I am just starting to get to know Acumatica much better

Noel P.

A150 Getting Started with Acumatica ERP

The instructor was thoroughly and reiterated the information to help it sink in

Lisa K.

D100 Inventory and Order Management Basics

I was very impressed that the full product - reconfigured with data was available The data was very well prepared