Exo Business API - Validation scripts for starting out

The following collection of data validation scripts are intended to make it easier to identify and correct Data problems that may affect the API. There are 3 sets of scripts provided here.

• Scripts for assistance with determining Data restraints for the API.
• Scripts for assistance with determining profile values that affect the API.
• Scripts for identifying illegal data values that the API will crash on.

Data Restraint scripts.

• Script for querying Data Dictionaries for Extra Fields.
  The purpose of this script is to make it easy to compile a list of data dictionaries for Extra Fields in a given database and the values of the data keys.
• Script for querying String Length for Exo tables.
  The purpose of this script is to make it easy to see the database lengths for various extra fields, in order to prevent String Truncation errors when submitting to API endpoints.

Profile Review script.

• Script for reviewing Profile values that often cause issues for OnTheGo or API users.
  Please note, this is not an exhaustive list of all Profiles that will interact with the API, but is intended to help identify profiles that often affect users.

Data Consistency script.

• Script for identifying illegal data values.
  The API handler reacts poorly to NULL values in particular.

Everything to do with API Configuration should be referred to either your IT Administrators or your Exo Business Implementation Partners, or your API Developer Partner. These pages are highly technical and intended for your Partner to work through.

You can also find more resources on the MYOB Exo Business Education Centre.