Jobs json

The jobs.json file defines the set of connector tasks to run during integration.

From Inistate to Accounting software

Sample Code [Accounting 1]

Each job entry specifies:

• name: Logical name of the task.

• enabled: true/false to turn this job on or off.

• server: Connection parameters (host, database, credentials).

• debug: Enable detailed logging.

• hook / errorHook / callBackHook : Web hook URLs for sync, error handle and callbacks.

• lastSync: Timestamp of the last run.

• interval: Polling interval in minutes.

jobs.json

Replace respective Logic script name in {LOGIC-NAME} for hook and errorHook.

"Logic": [
  {
    "name": "{NAME}",
    "enabled": false,
    "server": {
      "server": "{SERVER}",
      "database": "{DATABASE}",
      "dbUsername": "{DB_USERNAME}",
      "dbPassword": "{DB_PASSWORD}",
      "user": "{USERNAME}",
      "password": "{PASSWORD}"
    },
    "debug": false,
    "hook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
    "errorHook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
    "lastSync": "{LAST_SYNC_DATE_TIME}",
    "interval": 5
  }
]

jobs.json (with call back)

Sample Code [Accounting 2]

jobs.json

(Work In Progress)

jobs.json (with call back)

From Accounting Software to Inistate

Sample Code [Accounting 1]

jobs.json

"SQLSync": [
  {
    "name": "{NAME}",
    "enabled": false,
    "connectionString": "Data Source={SERVER};Initial Catalog={DATABASE};User Id={DB_USERNAME};Password={DB_PASSWORD};",
    "hook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
    "sql":  "SELECT DocKey,\r\n\t   DocNo,\r\n       SubmitEInvoice,\r\n       EInvoiceStatus,\r\n      
             EInvoiceAIPSubmissionDateTime,\r\n       EInvoiceUuid,\r\n       EInvoiceValidatedDateTime as LastModified,\r\n EInvoiceValidationLink\r\n
             FROM IV Where EInvoiceValidatedDateTime > DATEADD(MINUTE, -5, @date) Order By EInvoiceValidatedDateTime Asc",
    "lastSync": "{LAST-SYNC-DATE-TIME}",
    "debug": false,
    "interval": 5,
    "start": null
  }
]

Sample Code [Accounting 2]

The SQLSync section entry specifies:

• name: Logical identifier for the sync job.

• enabled: true/false to turn this job on or off.

• connectionString: A valid ADO-style string.

• hook: The callback URL to receive each batch of synced rows.

• sql: Your SQL script to select changed records.

• lastSync: Timestamp of the last run.

jobs.json

In order to sync, you must include LastModified in sql

"SQLSync": [
  {
    "name": "{NAME}",
    "enabled": false,
    "connectionString": "Data Source={SERVER};Initial Catalog={DATABASE};User Id={DB_USERNAME};Password={DB_PASSWORD};",
    "hook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
    "sql": "{SQL-QUERY-SCRIPT}",
    "lastSync": "{LAST-SYNC-DATE-TIME}",
    "start": null
  }
]