Skip to content

Fetchwhere App

Commands

  • The simplest way to get started is to clone this repository to a local directory.
  • git clone https://github.com/NSA-Computer-Exchange/Fetchwhere_App

Download

If you don't have git installed, you can download the files in .zip format:

  • Expand the green "Code" button.
  • Select Download ZIP at the bottom.

Download

For more information on cloning a repository, here's a good read: Cloning a repository

Config

You'll need to edit the config.ini file so it points to your tenant and your .ionapi credential file.

config/
    config.ini

Edit this line:

conoFetchUrl = https://mingle-ionapi.inforcloudsuite.com/TENANT_TRN/SX/rest/serviceinterface/proxy/FetchWhere

Replace the TENANT_TRN value in the Fetchwhere URL with your tenant.

Example: 

https://mingle-ionapi.inforcloudsuite.com/ACMECORP_TRN/SX/rest/serviceinterface/proxy/FetchWhere

From yor InforOS tenant, create a backend service and downlod the .ionapi credential file.
Save the .ionapi file in the config folder. You can name it anything you like and even save it anywhere you want but you will have to change the path and name in the config.ini file to point to the correct location and file.

config/
    mycredentials.ionapi

Edit this line to point to your file.

ionapi_file = ./config/mycredentials.ionapi

Editing the payload

You'll find the various payloads in the payloads folder. They are just examples that you can use or modify freely to suite your needs.

payloads/
    sasc.json
    sasoo.json
    sasp.json
    vaeh.json

Example: SASOO request

{  
    "CompanyNumber": 1000,
    "Operator": "sys",
    "TableName": "sasoo",
    "WhereClause": "cono = 1000 and oper2 = 'RT01'",
    "BatchSize": 0,
    "RestartRowID": "" 
}

Once you have the repository cloned or downloaded and your payload(s) setup, make sure you have adequate permissions on the root directory the code is installed in and proceed to Running the code