Skip to main content
Solved

Import by Scenario via Web Service Endpoint

  • November 19, 2024
  • 6 replies
  • 194 views
L
Freshman I
  • I retreive a list of shipment numbers that i need to confirm in Acumatica
  • I created an import scenario that accepts a csv file with “Shipment Nbr.” as the header.
  • I created a web service endpoint mapped to Import By Scenario Screen
  • I created an action called prepareImport
    • The action has a parameter called Name which is the Import Scenario name
  • Is it possible to send a list of shipment numbers in JSON format instead of csv through postman?
    • What would the payload look like?
      • Ive tried:

        • {

              "entity" : {

                  "ShipmentNbr" : {"value": "SHIP-0000002"}

              }

          }

        • {

              "entity": {

                  "Name": { "value": "LA - Confirm Shipments" },

                  "parameters": {

                      "Shipment Nbr.": {

                          "value": "SHIP-0000003"

                      }

                  }

              }

          }

    • Ive tried changing the url to pass the Name as a filter

How can I acheive this? Thank you.

Best answer by Dmitrii Naumov

​@LALBAUGH if you already run those import scenarios, then maybe you can just schedule it. Let it grab the new version of the file and import based on a schedule.

But either way, my point is that if you are fine running it via import scenario overnight, it should also be fine running it via API one by one overnight. 

6 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Dmitrii Naumov
  • Acumatica Moderator
  • November 19, 2024

I think your way of doing that is too complex. If you have the list of shipment nbrs you need to confirm, you can just do it directly via API with the default API endpoint, can’t you?

Chris Hackett
L
Freshman I
  • LALBAUGH
  • Author
  • Freshman I
  • November 19, 2024

The problem with that is we need to confirm anywhere from 500-2000+ shipments a day. We have a limit on how many API calls we can make. If you use the default API, you can only do one at a time. That is why I am trying to get the import scenario to work, so we only have to make one call. 

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Dmitrii Naumov
  • Acumatica Moderator
  • November 19, 2024

Well, I see what the issue is. But, I think, if your API limit does not allow you to process that many documents, maybe it’s also going to be out of the license limits even if you work around the API limitation. It’ll just hit the limit in a different place, e.g. number of CPU cores used or something else.

 

Also, 2000 shipment confirmations a day is like 40-60 minutes of processing with the smallest API license*. So, maybe you just do it overnight and it’s fine.

*Depends on the size of the shipment too.

*if you don’t have any other API integrations running 

Chris Hackett
L
Freshman I
  • LALBAUGH
  • Author
  • Freshman I
  • November 19, 2024

I see what you are saying. This would be something that would run at night. The size of the shipments are usually one line. We are already running these import scenarios manually with the same number of shipment confirmations. I am just trying to find a way to automate it.

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Dmitrii Naumov
  • Acumatica Moderator
  • Answer
  • November 20, 2024

​@LALBAUGH if you already run those import scenarios, then maybe you can just schedule it. Let it grab the new version of the file and import based on a schedule.

But either way, my point is that if you are fine running it via import scenario overnight, it should also be fine running it via API one by one overnight. 

Chris Hackett
S
Semi-Pro III
Forum|alt.badge.img
  • schneur96
  • Semi-Pro III
  • November 29, 2024

You can also look at the option of CSV with a FTP and file sync. You would need an FTP server as you middle man to drop off and pick up the file. 

Schneur Perl
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved