How to get sales data from Prism RetailPro POS system

 

Authentication Process

  1. Perform a GET on https://{SERVERNAME}/v1/rest/auth In the response look in the HTTP header for the Auth-Nonce
  2. Generate an Auth-Nonce-Response using the following calculation:
  3. Perform a GET on https://{SERVERNAME}/v1/rest/auth?usr={USER}&pwd={PASSWORD} with both the Auth-Nonce and the Auth-Nonce-Response values in the header. Replace the {USER} and {PASSWORD} with actual values.
  4. Read the Auth-Session value from the response. This is your session token and is used to identify your connection. It must be present in the header of all calls made for your session.
  5. Perform a GET on https://{SERVERNAME}/v1/rest/sit?ws={WORKSTATIONNAME} to claim a seat. (Don't forget to add the Token to the request header from step 4.)
  6. Main API to get Sales data: http://server/v1/rest/document?page_size=6&page_no=1&cols=*,item.*,tender.*&filter=(invoice_posted_date,ge,2021-10-24T00:00:00.000+00:00)

Where we need to send last run date-time and get all pages

This is how to configure in AllSync to automatic download sales data from PRISM:

  • Create new application PRISM
  • Create new sales table with fields we want to store data
  • Create an integration flow
  • Create a data mapper

AllSync introduces new feature for authentication list of API to be called.

Authorization:

Get Document:

 

Params:
filter = (invoice_posted_date,ge,{{applicationConfigurations.as_salesOrder_lastRun | minus:28800 | date: '%Y-%m-%d %H:%M:%S'}})

page_no=<{i}>

page_size=3

Back to blog