Implementing the Panatracker API

Implementing the Panatracker API

Implementation Steps

  1. Install the SubmitFromWebService license.
  2. Populate the appropriate Panatracker "Trx" tables with transactions that have a status of Queued. That is, column named TransactionStatus = 1.
  3. To trigger the submission, the web API endpoint needs to be called.

Example API Call

  1. http://t18:81/api/submit/SubmitQueued?companyName=PRODUCTION&trxsToSubmit=20

Parameters

  • companyName — The GP company name
  • trxsToSubmit — Defines a limit for the transactions to submit in a single batch to avoid overloading the process

The limit of 20 is a pretty good number to start. Ideally, call the API submit trigger often enough so that there are only a very few to be processed at once.

Triggering Options

There are a couple options to trigger the above call:

Use a SQL Job that runs every few minutes to call the submit webservice.

Application Integration

Change an application that you'd like to integrate with the PGP API to invoke the web service whenever a transaction needs to be queued. This would most-closely mimic how PGP actually works.

Windows Service

Write a Windows Service application that would run and periodically call the web service. This is not the optimal method.

Email Notifications

When the API is called and processes one or more transactions, it can send out an email indicating the transaction codes it created.

    • Related Articles

    • Reset Panatracker Administrator password

      If you have changed your Administrator password for PanatrackerGP and have forgotten it, you can reset it by running the SQL script below. Reset Procedure Access your SQL server with SQL Server Management Studio. Run the password reset script against ...

    • Implementing PanatrackerGP - Training

      Panatrack offers remote and on-site training options. Both options require a GP test company or environment for training and testing purposes. Training Options Remote Training — Functional training focused on system setup and configuration On-Site ...

    • Implementing PanatrackerGP-System Requirements

      Verify your environment meets these requirements before installing PanatrackerGP. Installation Components PanatrackerGP requires three installation components: SQL Server login account Intranet website using Microsoft IIS Client app on supported ...

    • Implementing Panatrack - Overview

      This guide outlines the PanatrackerGP implementation process from planning through go-live. Planning Successful implementation starts with thorough planning: Project Setup — Panatrack creates a project and assigns a project lead, importing standard ...

    • Panatracker Transaction Status code values

      The following table lists the values of the TransactionStatus field in PanatrackerGP transaction tables. Status Code Status Name Description 0 InProgress Transaction data is being gathered 1 Queued Saved for send, but submittal web service not yet ...