Leads

The Leads Table contains all the Leads Header Records. The Leads are linked to Lead Titles by the OppoID Key Field.

APIDescription
GET api/Leads?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Leads
POST api/Leads?strLeadData={strLeadData}

Used to Add/Create Lead Data

FormatPickList

The FormatPickList Table contains all the Look-Up Values for the Product Format Field. Each record also contains pre-defined Technical Details about the Format.

APIDescription
GET api/FormatPickList?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}

Used to look up Format PickList Data

Product

The Products Table contains all the assests linked to a Title/Episode linked using the TiCode Key Field.

APIDescription
GET api/Product?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&blnHideErrors={blnHideErrors}&strReturnFields={strReturnFields}

Used to look up Product Data
POST api/Product?strProductData={strProductData}&strProductTrackData={strProductTrackData}

Used to Add/Create Product Data
PUT api/Product?strSerialNos={strSerialNos}&strProductData={strProductData}&strProductTrackData={strProductTrackData}

Used to Update Product Records

RightsAvailable

The Rights Available End-Point returns a True or False result based upon a set of given parameters.

APIDescription
GET api/RightsAvailable?strTiCode={strTiCode}&intRightID={intRightID}&intTerrID={intTerrID}&dteStartDate={dteStartDate}&dteEndDate={dteEndDate}&strLanguage={strLanguage}&blnExclusive={blnExclusive}

Used to look up Rights Availablity

APOrderItems

The AR Invoices Table contains all the AR Invoice Headers. The AR Invoice Items are linked to an Invoice by the InvHeaderID Key Field.

APIDescription
GET api/APOrderItems?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up AR Invoices

ARInvoiceItems

The AR Invoice Items Table contains all the AR Invoice Line Items. The AR Invoice Items are linked to an Invoice by the InvHeaderID Key Field.

APIDescription
GET api/ARInvoiceItems?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up AR Invoice Items
POST api/ARInvoiceItems

Used to Add AR Invoice Items

AGLicStartDateChanges

Lists all Agreements where AR invoices have been created and subsequently a License Period Start Date has been changed or altered.

APIDescription
GET api/AGLicStartDateChanges?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Agreement License Period Start Date Changes
PUT api/AGLicStartDateChanges?strTiCode={strTiCode}&strContractNo={strContractNo}&blnUpdateCompleted={blnUpdateCompleted}

Used to Update Agreement License Period Start Date Changes

LeadItems

The Lead Item (Titles) Table contains all the Lead Titles Records. The Leads are linked to Lead Titles by the LeadID Key Field.

APIDescription
GET api/LeadItems?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Lead Items
POST api/LeadItems?lngLeadID={lngLeadID}&strLeadItemData={strLeadItemData}

Used to Add/Create Lead Item (Titles) Data

TitleField

APIDescription
GET api/TitleField?intLookUpField={intLookUpField}&intCompareOperator={intCompareOperator}&strLookUpData={strLookUpData}&intReturnField={intReturnField}

Used to look up Title Data Fields

ProductTracks

APIDescription
PUT api/ProductTracks?lngSerialNo={lngSerialNo}&strProductTrackData={strProductTrackData}&blnVerifyDataOnly={blnVerifyDataOnly}

Used to Update Product Track Data

Ping

APIDescription
GET api/Ping?strIP={strIP}

No documentation available.

PickList

The PickList Table contains all the Look-Up Values for any fields where a selection of predefined values is required in EasyTrack.

APIDescription
GET api/PickList?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}

Used to look up PickList Data

TitleData

The Title Table contains all Programmes in a Clients' Catalogue.

APIDescription
GET api/TitleData?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnType={strReturnType}&strReturnFields={strReturnFields}

Used to look up Title Data

APOrder

The AP Orders Table contains all the AP Order Headers. The AP Order Items are linked to an Order by the PONo Key Field.

APIDescription
GET api/APOrder?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up AR Invoices

Versions

Versions are applied to Episodes and Products but linked to a Title by the TiCode Key Field

APIDescription
GET api/Versions?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}

Used to look up Title Version Data (Individual)

ProductsMove

APIDescription
PUT api/ProductsMove?strSerialNos={strSerialNos}&strMoveToCOKey_ID={strMoveToCOKey_ID}&strAWB={strAWB}&strShipVia={strShipVia}&dteShipDate={dteShipDate}&strTransType={strTransType}

Used to Update Product Location

CRMContact

The CRM Contacts contacts the records for all CRM Contacts (People). These are linked to the CRM Account Table by the ACKey_ID Key Field.

APIDescription
GET api/CRMContact?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up CRM Contact Data
POST api/CRMContact?strContactData={strContactData}

Used to Add CRM Contact Records

ARReceipts

The AR Invoices Table contains all the AR Invoice Headers. The AR Invoice Items are linked to an Invoice by the InvHeaderID Key Field.

APIDescription
GET api/ARReceipts?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up AR Invoices
POST api/ARReceipts

Used to Add AR Receipts

APOrderStatus

The AP Order Status Table contains all the AP Order Status Records. The AP Order Statuses are linked to an Order by the PONo Key Field.

APIDescription
GET api/APOrderStatus?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up AR Invoices
POST api/APOrderStatus?strAPOrderStatusData={strAPOrderStatusData}

Used to Add/Create AP Order Status Data

ARAllocations

APIDescription
GET api/ARAllocations?strContractNo={strContractNo}&strTiCode={strTiCode}&dblAllocationValue={dblAllocationValue}&strAllocationType={strAllocationType}&strInvoiceNo={strInvoiceNo}

No documentation available.

AgreementTitles

The Agreement Titles Table contains all the Agreement Titles. The Agreement Titles are linked to an Agreement by the ContractNo Key Field.

APIDescription
GET api/AgreementTitles?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Agreement Titles

CRMAddress

APIDescription
GET api/CRMAddress?strCRMKey={strCRMKey}&strKeyType={strKeyType}

Used to look up CRM Address Data

Episodes

The Episodes Table contains all the data regarding epsiodes linked to a Title (by TiCode) and, if applicable, the Versions Table (by VersionCode).

APIDescription
GET api/Episodes?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Episode Data

The CRM Module Links Table contains CRM Keys releated to Module Objects.

APIDescription
GET api/CRMModuleLinks?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up CRM Module Links

ARInvoice

The AR Invoices Table contains all the AR Invoice Headers. The AR Invoice Items are linked to an Invoice by the InvHeaderID Key Field.

APIDescription
GET api/ARInvoice?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up AR Invoices
POST api/ARInvoice?strInvoiceData={strInvoiceData}

Used to Add AR Invoices

Agreements

The Agreement Table contains all the Sales Agreements.

APIDescription
GET api/Agreements?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Sales Agreements

CRMAccount

The CRM Accounts Table contains all the CRM entries for all Accounts (Companies). CRM Contacts (People) are linked to the Account by the ACKey_ID Key Field.

APIDescription
GET api/CRMAccount?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up CRM Account Data
POST api/CRMAccount?strAccountData={strAccountData}&blnBRValidation={blnBRValidation}

Used to Add CRM Account Records

APIInfo

The API Info Function allows you to query the Enumerations used in the EasyTrack API.

APIDescription
GET api/APIInfo?strType={strType}&intENumID={intENumID}

Used to look up API Enumerations

Packages

APIDescription
GET api/Packages?intLookUpField={intLookUpField}&strLookUpData={strLookUpData}&intCompareOperator={intCompareOperator}&strOrderBy={strOrderBy}&strReturnFields={strReturnFields}

Used to look up Title Packages