AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

Web Services for a Multi-Cloud World – xRP Summit 2017

June 22, 2017 by Tim Rodman

The first xRP Summit took place today. It was a virtual affair which is perfect for developers in my opinion. What a great way to share knowledge. Here are my notes from the Web Services session.

The next presentation is by Samuel-Oliver #xrpsummit pic.twitter.com/48OY2UZHac

— Tim Rodman (@TimRodman) June 21, 2017

Goals of this next session on Web Services #xrpsummit pic.twitter.com/AQAAKFIcdg

— Tim Rodman (@TimRodman) June 21, 2017

An overview of the APIs in #Acumatica #xrpsummit pic.twitter.com/tduKa7k9zh

— Tim Rodman (@TimRodman) June 21, 2017

Acumatica ships with a ton of web service endpoints. You can even extend them yourself if you want #xrpsummit pic.twitter.com/tnP9JVjtdC

— Tim Rodman (@TimRodman) June 21, 2017

You can package and publish your endpoints using XML or a customization project #xrpsummit pic.twitter.com/ozIzEHF13Y

— Tim Rodman (@TimRodman) June 21, 2017

Make sure you publish with cleanup when republishing a customization project with an endpoint that was already applied #xrpsummit pic.twitter.com/aU9U15T6DE

— Tim Rodman (@TimRodman) June 21, 2017

Logging in to Acumatica using Postman to start working with REST APIs #xrpsummit pic.twitter.com/RbcyzN2gpK

— Tim Rodman (@TimRodman) June 21, 2017

Logging into Acumatica using Visual Studio (can specify a company or branch to login to) #xrpsummit pic.twitter.com/Ujpbi0Gu5i

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving records from Acumatica using HTTP GET #xrpsummit pic.twitter.com/FmCvQkIulr

— Tim Rodman (@TimRodman) June 21, 2017

Be careful using $expand in the screenshot below. It can run slow on large datasets because of the large volume of data returned #xrpsummit pic.twitter.com/pC6EKJc4oy

— Tim Rodman (@TimRodman) June 21, 2017

"204 No Content" means that you logged into Acumatica successfully from Postman #xrpsummit pic.twitter.com/LOHB6N7bpH

— Tim Rodman (@TimRodman) June 21, 2017

This is the name of the endpoint #xrpsummit pic.twitter.com/m6bXGqIkPw

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving data from an endpoint using a filter #xrpsummit pic.twitter.com/uR9249a7yg

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving a whole list of records using a filter #xrpsummit pic.twitter.com/XEQAUZh1R7

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving just the top 5 records #xrpsummit pic.twitter.com/VKP3pRffDR

— Tim Rodman (@TimRodman) June 21, 2017

Skipping the first 18 records (I'm trying to think how this is useful) #xrpsummit pic.twitter.com/NWOcluNDoG

— Tim Rodman (@TimRodman) June 21, 2017

Automatically expanding details from a record in the API call #xrpsummit pic.twitter.com/EkZXhnQo4i

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving custom fields in an API call using $Custom #xrpsummit pic.twitter.com/7B69LioRcL

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving all stock items from visual studio #xrpsummit pic.twitter.com/dNMNhTpkb8

— Tim Rodman (@TimRodman) June 21, 2017

Retrieving all stock items with a filter using visual studio #xrpsummit pic.twitter.com/wNoGDR6cKP

— Tim Rodman (@TimRodman) June 21, 2017

Use can use the ID field that is returned in future API calls (like for updating data) #xrpsummit pic.twitter.com/WBLK1lDVgQ

— Tim Rodman (@TimRodman) June 21, 2017

Linked Entities are a 1-1 relationship to another record #xrpsummit pic.twitter.com/hu6NxZOGwJ

— Tim Rodman (@TimRodman) June 21, 2017

Detail Entities are a 1-many relationship to another record (like Sales Orders to Sales Orders Lines) #xrpsummit pic.twitter.com/vJ8tZukJtw

— Tim Rodman (@TimRodman) June 21, 2017

Creating records in Acumatica using HTTP PUT (make sure you know what the required fields are by looking at the screen first) #xrpsummit pic.twitter.com/vtqucY1PFH

— Tim Rodman (@TimRodman) June 21, 2017

Creating records in Acumatica using an API uses the same exact validation as if you typed it into the screen. That's HUGE! #xrpsummit pic.twitter.com/Vqm26xZA0S

— Tim Rodman (@TimRodman) June 21, 2017

Creating a Stock Item in Acumatica using web services #xrpsummit pic.twitter.com/8mQKznaFBa

— Tim Rodman (@TimRodman) June 21, 2017

You can also update records using web services. You select which fields in the record you want to update. #xrpsummit pic.twitter.com/BdXK3Uvj0P

— Tim Rodman (@TimRodman) June 21, 2017

You can use an empty string to clear a field's value #xrpsummit pic.twitter.com/GnoKCyyJvG

— Tim Rodman (@TimRodman) June 21, 2017

You use an update statement to delete records (like maybe sales order lines) #xrpsummit pic.twitter.com/rUocorUIkg

— Tim Rodman (@TimRodman) June 21, 2017

Updating the description of a stock item using the ID and web services #xrpsummit pic.twitter.com/vXA7ajHNcl

— Tim Rodman (@TimRodman) June 21, 2017

Many of the visual studio examples being shown are available as code samples in the I210 course: https://t.co/MAZGQM47rX #xrpsummit

— Tim Rodman (@TimRodman) June 21, 2017

To delete records using the API, you have to use the ID #xrpsummit pic.twitter.com/9RFniVyn96

— Tim Rodman (@TimRodman) June 21, 2017

If you try to delete a record twice, you will of course get an error #xrpsummit pic.twitter.com/L08OQ8ElPs

— Tim Rodman (@TimRodman) June 21, 2017

You can also retrieve and attach documents using web services which is pretty cool #xrpsummit pic.twitter.com/vbFYYP0rDv

— Tim Rodman (@TimRodman) June 21, 2017

Don't forget to logout when using a production site because it will create tons of user sessions (test sites limited to 2) #xrpsummit pic.twitter.com/AGklBpzYM9

— Tim Rodman (@TimRodman) June 21, 2017

Microsoft Flow integration that creates a case from a Tweet #xrpsummit pic.twitter.com/x6USt6LOrl

— Tim Rodman (@TimRodman) June 21, 2017

Hey, it found my tweets and brought them in during the demo (very cool) #xrpsummit pic.twitter.com/358RGK5XMh

— Tim Rodman (@TimRodman) June 21, 2017

More information on the Acumatica APIs #xrpsummit pic.twitter.com/e4iRgPAeZd

— Tim Rodman (@TimRodman) June 21, 2017

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica REST API, Acumatica Training, Acumatica Web Services, Acumatica xRP Summit 2017

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

Online Members

Recent Blog Posts

  • Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View January 26, 2021
  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Serial numbers in columns

    Hi Tim! Attached is my rpx. Odd Inge

    By ohalvors, 9 hours ago

  • RE: Serial numbers in columns

    Can you attach the .rpx file of the report that you're ...

    By Tim Rodman, 12 hours ago

  • RE: What is your role at your company?

    @dianne-a Sounds like you've had an interesting journey...

    By Tim Rodman, 20 hours ago

  • RE: What is your role at your company?

    My job title is Systems Analyst and I used to be a soft...

    By Dianne A, 20 hours ago

  • RE: Emailing Sales Orders / Quotes from Mobile App

    Hey Gustavo; did you ever get any where with this. I ha...

    By kevin.ruppert, 22 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    @ahmedbahar I am experiencing the same issue. I am on 2...

    By Adam-McGuinnes, 24 hours ago

  • Serial numbers in columns

    Hello! I am trying to print serial numbers in columns o...

    By ohalvors, 1 day ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I have the same issue and I use SubReport (in your case...

    By Idrus, 1 day ago

  • RE: Is the Parameter Schema Field Mandatory?

    I think it's required. Without it, Acumatica doesn't kn...

    By Tim Rodman, 2 days ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

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