Overview

Provides access to Company related data.

Endpoints

The resources available in this module.

CompanyListApi

Provides API access to the Companies (#/General/CompanyList.aspx) Web Workbench screen.

/api/CompanyListApi
Method	Performed As	Request Query	Request Body	Response
GET Retrieve the first 20 companies.	Logged in User	-	-	GridResult<CompanyLine>
POST Retrieve a filtered list of companies.	Logged in User	-	GridRequestParametersApi	GridResult<CompanyLine>

CompanyDetailApi

Provides API access to the Company Detail (#/General/CompanyList.aspx) dialog Web Workbench screen.

/api/CompanyDetailApi
Method	Performed As	Request Query	Request Body	Response
GET Retrieve a specific Company (including details, people, addresses and attributes).	Admin User	CompanyKey	-	CompanyApiModel
POST Update a Company ( or create, when Key.CompanyID = 0)	Admin User	-	CompanyApiModel	CompanyApiModel

Models

The definitions of models specific to endpoints in this module.

CompanyKey

Property	Type	Description
CompanyID	Integer	The unique Company ID of the Company

CompanyLine

Property	Type	Description
Key	CompanyKey	The unique key for the line.
CompanyId	Integer	The unique Company ID of the Company.
CompanyName	String	The name of the Company.
CompanyNameValue	CellData	The name of the Company.
AlphaCode	String	The shorthand code for the Company.
AlphaCodeValue	CellData	The shorthand code for the Company.
ApAccount	String	The AP linking code to the financial system.
ApAccountValue	CellData	The AP linking code to the financial system.
ArAccount	String	The AR linking code to the financial system.
ArAccountValue	CellData	The AR linking code to the financial system.
CreditStatus	String	The Company's credit status with your organization.
CreditStatusValue	CellData	The Company's credit status with your organization.
Location	String	The location the Company has been assigned to.
LocationValue	CellData	The location the Company has been assigned to.
FinancialCompanyCode	String	The internal Financial Company this company sits under.
FinancialCompanyCodeValue	CellData	The internal Financial Company this company sits under.
CompanyType	String	The company type of this Company.
CompanyTypeValue	CellData	The company type of this Company.
Phone	String	The Phone Number of this Company.
PhoneValue	CellData	The Phone Number of this Company.
Client	Boolean	The Client flag on the Company.
Supplier	Boolean	The Supplier flag on the Company.
Subcontractor	Boolean	The Subcontractor flag on the Company.
Other	Boolean	The Other flag on the Company.
Inactive	Boolean	The Inactive flag on the Company.
GSTNumber	String	The tax identifier for the Company.
CostValue	CellData	(if GridRequestParametersApi.IntValue2 is populated with an ItemID) The Cost on the Catalogue Line
CatalogueValue	CellData	(if GridRequestParametersApi.IntValue2 is populated with an ItemID) The Name of the Catalogue
Group1	String	The Attribute Group of the first Attribute Category filter
Group2	String	The Attribute Group of the second Attribute Category filter
Group3	String	The Attribute Group of the third Attribute Category filter
UpdatedDate	DateTime	The Date this record was last updated.

CompanyApiModel

Property	Type	Description
Key	CompanyKey	The unique key of the Company.
Main	CompanyMainFields	General data associated with the Company.
Financials	CompanyFinancialsFields	Financial data associated with the Company.
People.Rows	Array<PersonLine>	People associated with the Company.
Attributes.Rows	Array<AttributeLine>	Attributes associated with the Company.
CompanyInsurance.Rows	Array<CompanyInsuranceLine>	Company Insurances associated with the Company.
Addresses.Rows	Array<AddressLine>	Addresses associated with the Company.
Notes.Rows	Array<NoteLine>	Notes associated with the Company.
ToDoItems.Rows	Array<ToDoLine>	To Do Items associated with the Company.

⬆️ Back to top

CompanyMainFields

Property	Type	Description
CompanyID	StringViewData	Code The unique Company ID of the companyCompany.
CompanyName	StringViewData	The name of the Company name.
AlphaCode	StringViewData	The shorthand code for the companyCompany.
CompanyType	DropdownViewData	The type of the companyCompany.
PriceCode	PickerViewData	Price code of the companyCompany.
Location	PickerViewData	Location The location the Company has been assigned to company.
Branch	StringViewData	The Branch the Company belongs to.
FinancialCompany	DropdownViewData	The internal Financial Company this company Company sits under.
ArAccount	StringViewData	The AR linking code to the financial system.
ApAccount	StringViewData	The AP linking code to the financial system.
Currency	PickerViewData	The default currency Currency of the companyCompany.
CompanyReference	StringViewData	ReferenceThe reference.
InactiveCompany	BoolViewData	The Inactive statusflag on the Company.
Client	BoolViewData	Marked as Client or notThe Client flag on the Company.
Supplier	BoolViewData	Marked as Supplier or notThe Supplier flag on the Company.
Subcontractor	BoolViewData	Marked as Subcontractor or notThe Subcontractor flag on the Company.
Other	BoolViewData	Marked as Other or notThe Other flag on the Company.
GSTNumber	StringViewData	The tax identifier for the companyCompany.
DefaultJobManager	PickerViewData	The Person as who is the default Job managerManager.
DefaultAccountManager	PickerViewData	The Person as who is the default Account managerManager.

⬆️ Back to top

CompanyFinancialsFields

Property	Type	Description
PaymentTerms	DecimalViewData	The numerical value for days
PaymentTermsType	DropdownViewData	To nominate the payment terms for Job Sales Invoices to this company
CreditStatus	DropdownViewData	The company's credit status is with your organization
CashLimit	DecimalViewData	To nominate a cash limit.
BankAccountRef1	StringViewData	Account details.
BankAccountRef2	StringViewData	Account details.
BankAccountRef3	StringViewData	Account details.
UseGST	BoolViewData	Have tax or not.
CashOnly	BoolViewData	This company as a cash-only or not
UseBuyerCreatedInvoices	BoolViewData	Use the BCI/RCTI or not.

⬆️ Back to top

PersonLine

Property

Type

Description

PersonId

Integer

The unique ID of the Person

DisplayName

String

Displayed name.

Surname

String

Family name

FirstName

String

First name

CompanyId

Integer

The company id of the person.

Company

String

The company name of this person.

Role

String

Person role

.

JobTitle

String

User's official title.

EmailAddress

String

Email address.

MobilePhone

String

Mobile number

BusinessPhone

String

Working phone number

IsEmployee

Boolean

The person is an employee or not.

IsActive

Boolean

The account is active or not.

Inactive

Boolean

The account status is inactive or not.

IsBillingContact

Boolean

The person is the billing contact or not.

IsSiteContact

Boolean

The person is the Site contact or not.

IsCommercialContact

Boolean

The person is the Site Contact or not.

EmployeeNo

String

Employee code

SelectId

String

SelectTag

String

Select

CellData

PersonIdValue

CellData

Code of the person

SurnameValue

CellData

Surname of the person

FirstNameValue

CellData

First name of the person.

CompanyValue

CellData

Company of the person.

RoleValue

CellData

Person role.

JobTitleValue

CellData

User's official title.

EmailAddressValue

CellData

Person email address

MobilePhoneValue

CellData

Person mobile number

BusinessPhoneValue

CellData

Person business phone

Delete

CellData

Group1

String

The first Attribute Group.

Group2

String

The second Attribute Group.

Group3

String

The Third Attribute Group.

UpdatedDate

String

Updated date.

Status

String

ReadonlyFlag

Integer

ReadonlyMessage

String

OriginalKey

GeneralPersonKey

CurrentKey

GeneralPersonKey

Key

GeneralPersonKey

Index

Integer

⬆️ Back to top

Examples

Get list of first 20 companies.

Expand

title	Click to view

Request

Code Block

language	json

Response

Code Block

language	json

GridResult_GeneralCompanyLine {
total (integer, optional),
page (integer, optional),
records (integer, optional),
rows (Array[GeneralCompanyLine], optional),
form (object, optional),
widgets (Array[ViewData_GridWidget], optional)
}
GeneralCompanyLine {
CompanyId (integer, optional),
CompanyName (string, optional),
AlphaCode (string, optional),
ApAccount (string, optional),
ArAccount (string, optional),
CreditStatus (string, optional),
Location (string, optional),
FinancialCompanyCode (string, optional),
CompanyType (string, optional),
Phone (string, optional),
Client (boolean, optional),
Supplier (boolean, optional),
Subcontractor (boolean, optional),
Other (boolean, optional),
Inactive (boolean, optional),
GSTNumber (string, optional),
Select (CellData, optional),
CompanyNameValue (CellData, optional),
AlphaCodeValue (CellData, optional),
ApAccountValue (CellData, optional),
ArAccountValue (CellData, optional),
CreditStatusValue (CellData, optional),
LocationValue (CellData, optional),
FinancialCompanyCodeValue (CellData, optional),
CompanyTypeValue (CellData, optional),
PhoneValue (CellData, optional),
CostValue (CellData, optional),
CatalogueValue (CellData, optional),
Group1 (string, optional),
Group2 (string, optional),
Group3 (string, optional),
UpdatedDate (string, optional),
Status (string, optional),
ReadonlyFlag (integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (GeneralCompanyKey, optional),
CurrentKey (GeneralCompanyKey, optional),
Key (GeneralCompanyKey, optional),
Index (integer, optional)
}
ViewData_GridWidget {
WidgetId (integer, optional),
LayoutCode (string, optional),
Name (string, optional),
Colour (string, optional),
BGColour (string, optional),
Icon (string, optional),
Type (string, optional),
Visible (boolean, optional),
Order (integer, optional),
Count (integer, optional),
WidgetLines (Array[ViewData_GridWidgetLine], optional)
}
CellData {
CellId (string, optional),
CellValue (string, optional),
CellNumValue (number, optional),
CellBoolValue (boolean, optional),
CellTag (string, optional),
CellValueDate (string, optional),
CellValueInt (integer, optional)
}
GeneralCompanyKey {
CompanyId (integer)
}
ViewData_GridWidgetLine {
WidgetLineId (integer, optional),
WidgetId (integer, optional),
Name (string, optional),
Predicate (string, optional),
Order (integer, optional),
Count (integer, optional)
}

Response sample

Code Block

language	json

{
  "total": 15,
  "page": 1,
  "records": 285,
  "rows": [
    {
      "CompanyId": 596,
      "CompanyName": " Adatum Sandbox",
      "AlphaCode": "ADATUMCORP",
      "ApAccount": "10001",
      "ArAccount": "10000",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "03",
      "CompanyType": "GEN",
      "Phone": "22222221111",
      "Client": true,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "GSTNumber": "31608459409",
      "Select": {
        "CellId": "596",
        "CellValue": " Adatum Sandbox",
        "CellTag": " Adatum Sandbox"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": " Adatum Sandbox",
        "CellTag": "openDialog(\"596\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ADATUMCORP"
      },
      "ApAccountValue": {
        "CellValue": "10001"
      },
      "ArAccountValue": {
        "CellValue": "10000"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "03",
        "CellValue": "03 : ASIA / PACIFIC LABOUR (Business Cent)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "22222221111"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-09-22T03:00:51.4565009+00:00",
      "OriginalKey": {
        "CompanyId": 596
      },
      "CurrentKey": {
        "CompanyId": 596
      },
      "Key": {
        "CompanyId": 596
      },
      "Index": 0
    },
    {
      "CompanyId": 738,
      "CompanyName": "132 Collins",
      "AlphaCode": "132COLLINS",
      "ApAccount": "123COLL",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": " 03 3699876",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "738",
        "CellValue": "132 Collins",
        "CellTag": "132 Collins"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "132 Collins",
        "CellTag": "openDialog(\"738\")"
      },
      "AlphaCodeValue": {
        "CellValue": "132COLLINS"
      },
      "ApAccountValue": {
        "CellValue": "123COLL"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 03 3699876"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2024-02-26T23:23:24.3840362+00:00",
      "OriginalKey": {
        "CompanyId": 738
      },
      "CurrentKey": {
        "CompanyId": 738
      },
      "Key": {
        "CompanyId": 738
      },
      "Index": 0
    },
    {
      "CompanyId": 749,
      "CompanyName": "3M International 3",
      "AlphaCode": "3M INTERNA",
      "ArAccount": "3M",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "749",
        "CellValue": "3M International 3",
        "CellTag": "3M International 3"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "3M International 3",
        "CellTag": "openDialog(\"749\")"
      },
      "AlphaCodeValue": {
        "CellValue": "3M INTERNA"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "3M"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {},
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2024-02-29T02:47:23.487+00:00",
      "OriginalKey": {
        "CompanyId": 749
      },
      "CurrentKey": {
        "CompanyId": 749
      },
      "Key": {
        "CompanyId": 749
      },
      "Index": 0
    },
    {
      "CompanyId": 617,
      "CompanyName": "3M International 3",
      "AlphaCode": "3M INTERNA",
      "ApAccount": "4M",
      "ArAccount": "3M",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "02",
      "CompanyType": "GEN",
      "Client": true,
      "Supplier": false,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "617",
        "CellValue": "3M International 3",
        "CellTag": "3M International 3"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "3M International 3",
        "CellTag": "openDialog(\"617\")"
      },
      "AlphaCodeValue": {
        "CellValue": "3M INTERNA"
      },
      "ApAccountValue": {
        "CellValue": "4M"
      },
      "ArAccountValue": {
        "CellValue": "3M"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "02",
        "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {},
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-08-10T02:28:35.8535551+00:00",
      "OriginalKey": {
        "CompanyId": 617
      },
      "CurrentKey": {
        "CompanyId": 617
      },
      "Key": {
        "CompanyId": 617
      },
      "Index": 0
    },
    {
      "CompanyId": 613,
      "CompanyName": "7-Eleven",
      "AlphaCode": "7_ELEVEN",
      "ApAccount": "6621",
      "ArAccount": "X001",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "613",
        "CellValue": "7-Eleven",
        "CellTag": "7-Eleven"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "7-Eleven",
        "CellTag": "openDialog(\"613\")"
      },
      "AlphaCodeValue": {
        "CellValue": "7_ELEVEN"
      },
      "ApAccountValue": {
        "CellValue": "6621"
      },
      "ArAccountValue": {
        "CellValue": "X001"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-03-12T00:02:07.2149894+00:00",
      "OriginalKey": {
        "CompanyId": 613
      },
      "CurrentKey": {
        "CompanyId": 613
      },
      "Key": {
        "CompanyId": 613
      },
      "Index": 0
    },
    {
      "CompanyId": 712,
      "CompanyName": "7-Eleven",
      "AlphaCode": "7_ELEVEN",
      "ArAccount": "7Elev1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "712",
        "CellValue": "7-Eleven",
        "CellTag": "7-Eleven"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "7-Eleven",
        "CellTag": "openDialog(\"712\")"
      },
      "AlphaCodeValue": {
        "CellValue": "7_ELEVEN"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "7Elev1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-07-20T04:34:49.7561455+00:00",
      "OriginalKey": {
        "CompanyId": 712
      },
      "CurrentKey": {
        "CompanyId": 712
      },
      "Key": {
        "CompanyId": 712
      },
      "Index": 0
    },
    {
      "CompanyId": 645,
      "CompanyName": "A & B CONSTRUCTIONS LTD",
      "AlphaCode": "A&BCONSTRU",
      "ApAccount": "20044",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "6582999231",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "GSTNumber": "11 223 344 555",
      "Select": {
        "CellId": "645",
        "CellValue": "A & B CONSTRUCTIONS LTD",
        "CellTag": "A & B CONSTRUCTIONS LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "A & B CONSTRUCTIONS LTD",
        "CellTag": "openDialog(\"645\")"
      },
      "AlphaCodeValue": {
        "CellValue": "A&BCONSTRU"
      },
      "ApAccountValue": {
        "CellValue": "20044"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "6582999231"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-03-31T11:22:12.003+00:00",
      "OriginalKey": {
        "CompanyId": 645
      },
      "CurrentKey": {
        "CompanyId": 645
      },
      "Key": {
        "CompanyId": 645
      },
      "Index": 0
    },
    {
      "CompanyId": 498,
      "CompanyName": "A & B CONSTRUCTIONS PTY LTD",
      "AlphaCode": "A & B CONS",
      "ApAccount": "266",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "7762800461",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "498",
        "CellValue": "A & B CONSTRUCTIONS PTY LTD",
        "CellTag": "A & B CONSTRUCTIONS PTY LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "A & B CONSTRUCTIONS PTY LTD",
        "CellTag": "openDialog(\"498\")"
      },
      "AlphaCodeValue": {
        "CellValue": "A & B CONS"
      },
      "ApAccountValue": {
        "CellValue": "266"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "7762800461"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2022-04-25T21:14:14.9809085+00:00",
      "OriginalKey": {
        "CompanyId": 498
      },
      "CurrentKey": {
        "CompanyId": 498
      },
      "Key": {
        "CompanyId": 498
      },
      "Index": 0
    },
    {
      "CompanyId": 521,
      "CompanyName": "ABC & 123 PLUMBER LTD",
      "AlphaCode": "ABC & 123 ",
      "ApAccount": "289",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "3702820496",
      "Client": false,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "521",
        "CellValue": "ABC & 123 PLUMBER LTD",
        "CellTag": "ABC & 123 PLUMBER LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC & 123 PLUMBER LTD",
        "CellTag": "openDialog(\"521\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABC & 123 "
      },
      "ApAccountValue": {
        "CellValue": "289"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "3702820496"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-01-31T01:16:17.8709216+00:00",
      "OriginalKey": {
        "CompanyId": 521
      },
      "CurrentKey": {
        "CompanyId": 521
      },
      "Key": {
        "CompanyId": 521
      },
      "Index": 0
    },
    {
      "CompanyId": 612,
      "CompanyName": "ABC Furniture",
      "AlphaCode": "ABCFURNITU",
      "ApAccount": "X002",
      "ArAccount": "X002",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": " 0800 124578",
      "Client": true,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "612",
        "CellValue": "ABC Furniture",
        "CellTag": "ABC Furniture"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC Furniture",
        "CellTag": "openDialog(\"612\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABCFURNITU"
      },
      "ApAccountValue": {
        "CellValue": "X002"
      },
      "ArAccountValue": {
        "CellValue": "X002"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 0800 124578"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-09-13T01:48:43.9832641+00:00",
      "OriginalKey": {
        "CompanyId": 612
      },
      "CurrentKey": {
        "CompanyId": 612
      },
      "Key": {
        "CompanyId": 612
      },
      "Index": 0
    },
    {
      "CompanyId": 649,
      "CompanyName": "ABC Furniture",
      "AlphaCode": "ABCFURNITU",
      "ArAccount": "ABCFu1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": " 0800 124578",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "649",
        "CellValue": "ABC Furniture",
        "CellTag": "ABC Furniture"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC Furniture",
        "CellTag": "openDialog(\"649\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABCFURNITU"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABCFu1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 0800 124578"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-04-05T04:33:01.11+00:00",
      "OriginalKey": {
        "CompanyId": 649
      },
      "CurrentKey": {
        "CompanyId": 649
      },
      "Key": {
        "CompanyId": 649
      },
      "Index": 0
    },
    {
      "CompanyId": 690,
      "CompanyName": "ABC Furniture",
      "AlphaCode": "ABCFURNITU",
      "ArAccount": "ABCFu1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": " 0800 124578",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "690",
        "CellValue": "ABC Furniture",
        "CellTag": "ABC Furniture"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC Furniture",
        "CellTag": "openDialog(\"690\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABCFURNITU"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABCFu1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 0800 124578"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-04-05T05:09:18.59+00:00",
      "OriginalKey": {
        "CompanyId": 690
      },
      "CurrentKey": {
        "CompanyId": 690
      },
      "Key": {
        "CompanyId": 690
      },
      "Index": 0
    },
    {
      "CompanyId": 616,
      "CompanyName": "ABC RESOURCE CO SM Test Mar 2022",
      "AlphaCode": "ABC RESOUR",
      "ArAccount": "ABCRESOURC",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "02",
      "CompanyType": "GEN",
      "Phone": "61396546989",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "616",
        "CellValue": "ABC RESOURCE CO SM Test Mar 2022",
        "CellTag": "ABC RESOURCE CO SM Test Mar 2022"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC RESOURCE CO SM Test Mar 2022",
        "CellTag": "openDialog(\"616\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABC RESOUR"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABCRESOURC"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "02",
        "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "61396546989"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2022-05-11T04:29:51.257+00:00",
      "OriginalKey": {
        "CompanyId": 616
      },
      "CurrentKey": {
        "CompanyId": 616
      },
      "Key": {
        "CompanyId": 616
      },
      "Index": 0
    },
    {
      "CompanyId": 6,
      "CompanyName": "ABC RESOURCE COMP LTD",
      "AlphaCode": "ABC RESOUR",
      "ApAccount": "test",
      "ArAccount": "ABCRESOURC",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "61396546989",
      "Client": true,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "6",
        "CellValue": "ABC RESOURCE COMP LTD",
        "CellTag": "ABC RESOURCE COMP LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC RESOURCE COMP LTD",
        "CellTag": "openDialog(\"6\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABC RESOUR"
      },
      "ApAccountValue": {
        "CellValue": "test"
      },
      "ArAccountValue": {
        "CellValue": "ABCRESOURC"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "61396546989"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2024-03-07T20:58:20.2796344+00:00",
      "OriginalKey": {
        "CompanyId": 6
      },
      "CurrentKey": {
        "CompanyId": 6
      },
      "Key": {
        "CompanyId": 6
      },
      "Index": 0
    },
    {
      "CompanyId": 647,
      "CompanyName": "ABPA1",
      "AlphaCode": "ABPA",
      "ApAccount": "ABPAAR",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "647",
        "CellValue": "ABPA1",
        "CellTag": "ABPA1"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABPA1",
        "CellTag": "openDialog(\"647\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABPA"
      },
      "ApAccountValue": {
        "CellValue": "ABPAAR"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-11-30T22:40:31.6512052+00:00",
      "OriginalKey": {
        "CompanyId": 647
      },
      "CurrentKey": {
        "CompanyId": 647
      },
      "Key": {
        "CompanyId": 647
      },
      "Index": 0
    },
    {
      "CompanyId": 648,
      "CompanyName": "ABPA1a",
      "AlphaCode": "ABPA",
      "ArAccount": "ABPA1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "648",
        "CellValue": "ABPA1a",
        "CellTag": "ABPA1a"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABPA1a",
        "CellTag": "openDialog(\"648\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABPA"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABPA1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-10-31T01:54:55.9741035+00:00",
      "OriginalKey": {
        "CompanyId": 648
      },
      "CurrentKey": {
        "CompanyId": 648
      },
      "Key": {
        "CompanyId": 648
      },
      "Index": 0
    },
    {
      "CompanyId": 646,
      "CompanyName": "ABPA4",
      "AlphaCode": "ABPA",
      "ApAccount": "ABPA1",
      "ArAccount": "ABPA1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "646",
        "CellValue": "ABPA4",
        "CellTag": "ABPA4"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABPA4",
        "CellTag": "openDialog(\"646\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABPA"
      },
      "ApAccountValue": {
        "CellValue": "ABPA1"
      },
      "ArAccountValue": {
        "CellValue": "ABPA1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-07-24T23:30:57.5847388+00:00",
      "OriginalKey": {
        "CompanyId": 646
      },
      "CurrentKey": {
        "CompanyId": 646
      },
      "Key": {
        "CompanyId": 646
      },
      "Index": 0
    },
    {
      "CompanyId": 636,
      "CompanyName": "ACT HIRE",
      "AlphaCode": "ACTHIRE",
      "ApAccount": "20001",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "+614421676915",
      "Client": false,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "636",
        "CellValue": "ACT HIRE",
        "CellTag": "ACT HIRE"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ACT HIRE",
        "CellTag": "openDialog(\"636\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ACTHIRE"
      },
      "ApAccountValue": {
        "CellValue": "20001"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "+614421676915"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-08-10T02:44:27.8697641+00:00",
      "OriginalKey": {
        "CompanyId": 636
      },
      "CurrentKey": {
        "CompanyId": 636
      },
      "Key": {
        "CompanyId": 636
      },
      "Index": 0
    },
    {
      "CompanyId": 455,
      "CompanyName": "ACT HIRE 2020",
      "AlphaCode": "ACT HIRE 2",
      "ApAccount": "223",
      "CreditStatus": "Credit",
      "Location": "EQUIP",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "6582999231",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "455",
        "CellValue": "ACT HIRE 2020",
        "CellTag": "ACT HIRE 2020"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ACT HIRE 2020",
        "CellTag": "openDialog(\"455\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ACT HIRE 2"
      },
      "ApAccountValue": {
        "CellValue": "223"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "EQUIP",
        "CellValue": "EQUIP : Equipment"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "6582999231"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2022-09-12T02:54:49.4431434+00:00",
      "OriginalKey": {
        "CompanyId": 455
      },
      "CurrentKey": {
        "CompanyId": 455
      },
      "Key": {
        "CompanyId": 455
      },
      "Index": 0
    },
    {
      "CompanyId": 615,
      "CompanyName": "ACT HIRE 2020 US",
      "AlphaCode": "ACT HIRE 2",
      "ApAccount": "223",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "02",
      "CompanyType": "GEN",
      "Phone": "6582999231",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "615",
        "CellValue": "ACT HIRE 2020 US",
        "CellTag": "ACT HIRE 2020 US"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ACT HIRE 2020 US",
        "CellTag": "openDialog(\"615\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ACT HIRE 2"
      },
      "ApAccountValue": {
        "CellValue": "223"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "02",
        "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "6582999231"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-04-19T01:19:51.4653571+00:00",
      "OriginalKey": {
        "CompanyId": 615
      },
      "CurrentKey": {
        "CompanyId": 615
      },
      "Key": {
        "CompanyId": 615
      },
      "Index": 0
    }
  ]
}

Get the list of all Workbench companies.

Expand

title	Click to view

Request

Code Block

language	json

Response

Code Block

language	json

{
  "total": 0,
  "page": 0,
  "records": 0,
  "rows": [
    {
      "CompanyId": 0,
      "CompanyName": "string",
      "AlphaCode": "string",
      "ApAccount": "string",
      "ArAccount": "string",
      "CreditStatus": "string",
      "Location": "string",
      "FinancialCompanyCode": "string",
      "CompanyType": "string",
      "Phone": "string",
      "Client": true,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": true,
      "GSTNumber": "string",
      "Select": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "CompanyNameValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "AlphaCodeValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "ApAccountValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "ArAccountValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "CreditStatusValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "LocationValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "FinancialCompanyCodeValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "CompanyTypeValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "PhoneValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.689Z",
        "CellValueInt": 0
      },
      "CostValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.690Z",
        "CellValueInt": 0
      },
      "CatalogueValue": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-04-05T02:31:14.690Z",
        "CellValueInt": 0
      },
      "Group1": "string",
      "Group2": "string",
      "Group3": "string",
      "UpdatedDate": "2024-04-05T02:31:14.690Z",
      "Status": "string",
      "ReadonlyFlag": 0,
      "ReadonlyMessage": "string",
      "OriginalKey": {
        "CompanyId": 0
      },
      "CurrentKey": {
        "CompanyId": 0
      },
      "Key": {
        "CompanyId": 0
      },
      "Index": 0
    }
  ],
  "form": {},
  "widgets": [
    {
      "WidgetId": 0,
      "LayoutCode": "string",
      "Name": "string",
      "Colour": "string",
      "BGColour": "string",
      "Icon": "string",
      "Type": "string",
      "Visible": true,
      "Order": 0,
      "Count": 0,
      "WidgetLines": [
        {
          "WidgetLineId": 0,
          "WidgetId": 0,
          "Name": "string",
          "Predicate": "string",
          "Order": 0,
          "Count": 0
        }
      ]
    }
  ]
}

Response sample

Code Block

language	json

{
  "total": 15,
  "page": 1,
  "records": 285,
  "rows": [
    {
      "CompanyId": 596,
      "CompanyName": " Adatum Sandbox",
      "AlphaCode": "ADATUMCORP",
      "ApAccount": "10001",
      "ArAccount": "10000",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "03",
      "CompanyType": "GEN",
      "Phone": "22222221111",
      "Client": true,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "GSTNumber": "31608459409",
      "Select": {
        "CellId": "596",
        "CellValue": " Adatum Sandbox",
        "CellTag": " Adatum Sandbox"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": " Adatum Sandbox",
        "CellTag": "openDialog(\"596\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ADATUMCORP"
      },
      "ApAccountValue": {
        "CellValue": "10001"
      },
      "ArAccountValue": {
        "CellValue": "10000"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "03",
        "CellValue": "03 : ASIA / PACIFIC LABOUR (Business Cent)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "22222221111"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-09-22T03:00:51.4565009+00:00",
      "OriginalKey": {
        "CompanyId": 596
      },
      "CurrentKey": {
        "CompanyId": 596
      },
      "Key": {
        "CompanyId": 596
      },
      "Index": 0
    },
    {
      "CompanyId": 738,
      "CompanyName": "132 Collins",
      "AlphaCode": "132COLLINS",
      "ApAccount": "123COLL",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": " 03 3699876",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "738",
        "CellValue": "132 Collins",
        "CellTag": "132 Collins"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "132 Collins",
        "CellTag": "openDialog(\"738\")"
      },
      "AlphaCodeValue": {
        "CellValue": "132COLLINS"
      },
      "ApAccountValue": {
        "CellValue": "123COLL"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 03 3699876"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2024-02-26T23:23:24.3840362+00:00",
      "OriginalKey": {
        "CompanyId": 738
      },
      "CurrentKey": {
        "CompanyId": 738
      },
      "Key": {
        "CompanyId": 738
      },
      "Index": 0
    },
    {
      "CompanyId": 749,
      "CompanyName": "3M International 3",
      "AlphaCode": "3M INTERNA",
      "ArAccount": "3M",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "749",
        "CellValue": "3M International 3",
        "CellTag": "3M International 3"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "3M International 3",
        "CellTag": "openDialog(\"749\")"
      },
      "AlphaCodeValue": {
        "CellValue": "3M INTERNA"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "3M"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {},
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2024-02-29T02:47:23.487+00:00",
      "OriginalKey": {
        "CompanyId": 749
      },
      "CurrentKey": {
        "CompanyId": 749
      },
      "Key": {
        "CompanyId": 749
      },
      "Index": 0
    },
    {
      "CompanyId": 617,
      "CompanyName": "3M International 3",
      "AlphaCode": "3M INTERNA",
      "ApAccount": "4M",
      "ArAccount": "3M",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "02",
      "CompanyType": "GEN",
      "Client": true,
      "Supplier": false,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "617",
        "CellValue": "3M International 3",
        "CellTag": "3M International 3"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "3M International 3",
        "CellTag": "openDialog(\"617\")"
      },
      "AlphaCodeValue": {
        "CellValue": "3M INTERNA"
      },
      "ApAccountValue": {
        "CellValue": "4M"
      },
      "ArAccountValue": {
        "CellValue": "3M"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "02",
        "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {},
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-08-10T02:28:35.8535551+00:00",
      "OriginalKey": {
        "CompanyId": 617
      },
      "CurrentKey": {
        "CompanyId": 617
      },
      "Key": {
        "CompanyId": 617
      },
      "Index": 0
    },
    {
      "CompanyId": 613,
      "CompanyName": "7-Eleven",
      "AlphaCode": "7_ELEVEN",
      "ApAccount": "6621",
      "ArAccount": "X001",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "613",
        "CellValue": "7-Eleven",
        "CellTag": "7-Eleven"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "7-Eleven",
        "CellTag": "openDialog(\"613\")"
      },
      "AlphaCodeValue": {
        "CellValue": "7_ELEVEN"
      },
      "ApAccountValue": {
        "CellValue": "6621"
      },
      "ArAccountValue": {
        "CellValue": "X001"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-03-12T00:02:07.2149894+00:00",
      "OriginalKey": {
        "CompanyId": 613
      },
      "CurrentKey": {
        "CompanyId": 613
      },
      "Key": {
        "CompanyId": 613
      },
      "Index": 0
    },
    {
      "CompanyId": 712,
      "CompanyName": "7-Eleven",
      "AlphaCode": "7_ELEVEN",
      "ArAccount": "7Elev1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "712",
        "CellValue": "7-Eleven",
        "CellTag": "7-Eleven"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "7-Eleven",
        "CellTag": "openDialog(\"712\")"
      },
      "AlphaCodeValue": {
        "CellValue": "7_ELEVEN"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "7Elev1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-07-20T04:34:49.7561455+00:00",
      "OriginalKey": {
        "CompanyId": 712
      },
      "CurrentKey": {
        "CompanyId": 712
      },
      "Key": {
        "CompanyId": 712
      },
      "Index": 0
    },
    {
      "CompanyId": 645,
      "CompanyName": "A & B CONSTRUCTIONS LTD",
      "AlphaCode": "A&BCONSTRU",
      "ApAccount": "20044",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "6582999231",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "GSTNumber": "11 223 344 555",
      "Select": {
        "CellId": "645",
        "CellValue": "A & B CONSTRUCTIONS LTD",
        "CellTag": "A & B CONSTRUCTIONS LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "A & B CONSTRUCTIONS LTD",
        "CellTag": "openDialog(\"645\")"
      },
      "AlphaCodeValue": {
        "CellValue": "A&BCONSTRU"
      },
      "ApAccountValue": {
        "CellValue": "20044"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "6582999231"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-03-31T11:22:12.003+00:00",
      "OriginalKey": {
        "CompanyId": 645
      },
      "CurrentKey": {
        "CompanyId": 645
      },
      "Key": {
        "CompanyId": 645
      },
      "Index": 0
    },
    {
      "CompanyId": 498,
      "CompanyName": "A & B CONSTRUCTIONS PTY LTD",
      "AlphaCode": "A & B CONS",
      "ApAccount": "266",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "7762800461",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "498",
        "CellValue": "A & B CONSTRUCTIONS PTY LTD",
        "CellTag": "A & B CONSTRUCTIONS PTY LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "A & B CONSTRUCTIONS PTY LTD",
        "CellTag": "openDialog(\"498\")"
      },
      "AlphaCodeValue": {
        "CellValue": "A & B CONS"
      },
      "ApAccountValue": {
        "CellValue": "266"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "7762800461"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2022-04-25T21:14:14.9809085+00:00",
      "OriginalKey": {
        "CompanyId": 498
      },
      "CurrentKey": {
        "CompanyId": 498
      },
      "Key": {
        "CompanyId": 498
      },
      "Index": 0
    },
    {
      "CompanyId": 521,
      "CompanyName": "ABC & 123 PLUMBER LTD",
      "AlphaCode": "ABC & 123 ",
      "ApAccount": "289",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "3702820496",
      "Client": false,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "521",
        "CellValue": "ABC & 123 PLUMBER LTD",
        "CellTag": "ABC & 123 PLUMBER LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC & 123 PLUMBER LTD",
        "CellTag": "openDialog(\"521\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABC & 123 "
      },
      "ApAccountValue": {
        "CellValue": "289"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "3702820496"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-01-31T01:16:17.8709216+00:00",
      "OriginalKey": {
        "CompanyId": 521
      },
      "CurrentKey": {
        "CompanyId": 521
      },
      "Key": {
        "CompanyId": 521
      },
      "Index": 0
    },
    {
      "CompanyId": 612,
      "CompanyName": "ABC Furniture",
      "AlphaCode": "ABCFURNITU",
      "ApAccount": "X002",
      "ArAccount": "X002",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": " 0800 124578",
      "Client": true,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "612",
        "CellValue": "ABC Furniture",
        "CellTag": "ABC Furniture"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC Furniture",
        "CellTag": "openDialog(\"612\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABCFURNITU"
      },
      "ApAccountValue": {
        "CellValue": "X002"
      },
      "ArAccountValue": {
        "CellValue": "X002"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 0800 124578"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-09-13T01:48:43.9832641+00:00",
      "OriginalKey": {
        "CompanyId": 612
      },
      "CurrentKey": {
        "CompanyId": 612
      },
      "Key": {
        "CompanyId": 612
      },
      "Index": 0
    },
    {
      "CompanyId": 649,
      "CompanyName": "ABC Furniture",
      "AlphaCode": "ABCFURNITU",
      "ArAccount": "ABCFu1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": " 0800 124578",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "649",
        "CellValue": "ABC Furniture",
        "CellTag": "ABC Furniture"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC Furniture",
        "CellTag": "openDialog(\"649\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABCFURNITU"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABCFu1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 0800 124578"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-04-05T04:33:01.11+00:00",
      "OriginalKey": {
        "CompanyId": 649
      },
      "CurrentKey": {
        "CompanyId": 649
      },
      "Key": {
        "CompanyId": 649
      },
      "Index": 0
    },
    {
      "CompanyId": 690,
      "CompanyName": "ABC Furniture",
      "AlphaCode": "ABCFURNITU",
      "ArAccount": "ABCFu1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": " 0800 124578",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "690",
        "CellValue": "ABC Furniture",
        "CellTag": "ABC Furniture"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC Furniture",
        "CellTag": "openDialog(\"690\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABCFURNITU"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABCFu1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": " 0800 124578"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-04-05T05:09:18.59+00:00",
      "OriginalKey": {
        "CompanyId": 690
      },
      "CurrentKey": {
        "CompanyId": 690
      },
      "Key": {
        "CompanyId": 690
      },
      "Index": 0
    },
    {
      "CompanyId": 616,
      "CompanyName": "ABC RESOURCE CO SM Test Mar 2022",
      "AlphaCode": "ABC RESOUR",
      "ArAccount": "ABCRESOURC",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "02",
      "CompanyType": "GEN",
      "Phone": "61396546989",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "616",
        "CellValue": "ABC RESOURCE CO SM Test Mar 2022",
        "CellTag": "ABC RESOURCE CO SM Test Mar 2022"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC RESOURCE CO SM Test Mar 2022",
        "CellTag": "openDialog(\"616\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABC RESOUR"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABCRESOURC"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "02",
        "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "61396546989"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2022-05-11T04:29:51.257+00:00",
      "OriginalKey": {
        "CompanyId": 616
      },
      "CurrentKey": {
        "CompanyId": 616
      },
      "Key": {
        "CompanyId": 616
      },
      "Index": 0
    },
    {
      "CompanyId": 6,
      "CompanyName": "ABC RESOURCE COMP LTD",
      "AlphaCode": "ABC RESOUR",
      "ApAccount": "test",
      "ArAccount": "ABCRESOURC",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "61396546989",
      "Client": true,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "6",
        "CellValue": "ABC RESOURCE COMP LTD",
        "CellTag": "ABC RESOURCE COMP LTD"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABC RESOURCE COMP LTD",
        "CellTag": "openDialog(\"6\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABC RESOUR"
      },
      "ApAccountValue": {
        "CellValue": "test"
      },
      "ArAccountValue": {
        "CellValue": "ABCRESOURC"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "61396546989"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2024-03-07T20:58:20.2796344+00:00",
      "OriginalKey": {
        "CompanyId": 6
      },
      "CurrentKey": {
        "CompanyId": 6
      },
      "Key": {
        "CompanyId": 6
      },
      "Index": 0
    },
    {
      "CompanyId": 647,
      "CompanyName": "ABPA1",
      "AlphaCode": "ABPA",
      "ApAccount": "ABPAAR",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "647",
        "CellValue": "ABPA1",
        "CellTag": "ABPA1"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABPA1",
        "CellTag": "openDialog(\"647\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABPA"
      },
      "ApAccountValue": {
        "CellValue": "ABPAAR"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-11-30T22:40:31.6512052+00:00",
      "OriginalKey": {
        "CompanyId": 647
      },
      "CurrentKey": {
        "CompanyId": 647
      },
      "Key": {
        "CompanyId": 647
      },
      "Index": 0
    },
    {
      "CompanyId": 648,
      "CompanyName": "ABPA1a",
      "AlphaCode": "ABPA",
      "ArAccount": "ABPA1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": false,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "648",
        "CellValue": "ABPA1a",
        "CellTag": "ABPA1a"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABPA1a",
        "CellTag": "openDialog(\"648\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABPA"
      },
      "ApAccountValue": {},
      "ArAccountValue": {
        "CellValue": "ABPA1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-10-31T01:54:55.9741035+00:00",
      "OriginalKey": {
        "CompanyId": 648
      },
      "CurrentKey": {
        "CompanyId": 648
      },
      "Key": {
        "CompanyId": 648
      },
      "Index": 0
    },
    {
      "CompanyId": 646,
      "CompanyName": "ABPA4",
      "AlphaCode": "ABPA",
      "ApAccount": "ABPA1",
      "ArAccount": "ABPA1",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "04",
      "CompanyType": "GEN",
      "Phone": "  ",
      "Client": true,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "646",
        "CellValue": "ABPA4",
        "CellTag": "ABPA4"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ABPA4",
        "CellTag": "openDialog(\"646\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ABPA"
      },
      "ApAccountValue": {
        "CellValue": "ABPA1"
      },
      "ArAccountValue": {
        "CellValue": "ABPA1"
      },
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "04",
        "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "  "
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-07-24T23:30:57.5847388+00:00",
      "OriginalKey": {
        "CompanyId": 646
      },
      "CurrentKey": {
        "CompanyId": 646
      },
      "Key": {
        "CompanyId": 646
      },
      "Index": 0
    },
    {
      "CompanyId": 636,
      "CompanyName": "ACT HIRE",
      "AlphaCode": "ACTHIRE",
      "ApAccount": "20001",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "+614421676915",
      "Client": false,
      "Supplier": true,
      "Subcontractor": true,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "636",
        "CellValue": "ACT HIRE",
        "CellTag": "ACT HIRE"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ACT HIRE",
        "CellTag": "openDialog(\"636\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ACTHIRE"
      },
      "ApAccountValue": {
        "CellValue": "20001"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "+614421676915"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-08-10T02:44:27.8697641+00:00",
      "OriginalKey": {
        "CompanyId": 636
      },
      "CurrentKey": {
        "CompanyId": 636
      },
      "Key": {
        "CompanyId": 636
      },
      "Index": 0
    },
    {
      "CompanyId": 455,
      "CompanyName": "ACT HIRE 2020",
      "AlphaCode": "ACT HIRE 2",
      "ApAccount": "223",
      "CreditStatus": "Credit",
      "Location": "EQUIP",
      "FinancialCompanyCode": "01",
      "CompanyType": "GEN",
      "Phone": "6582999231",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "455",
        "CellValue": "ACT HIRE 2020",
        "CellTag": "ACT HIRE 2020"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ACT HIRE 2020",
        "CellTag": "openDialog(\"455\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ACT HIRE 2"
      },
      "ApAccountValue": {
        "CellValue": "223"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "EQUIP",
        "CellValue": "EQUIP : Equipment"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "01",
        "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "6582999231"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2022-09-12T02:54:49.4431434+00:00",
      "OriginalKey": {
        "CompanyId": 455
      },
      "CurrentKey": {
        "CompanyId": 455
      },
      "Key": {
        "CompanyId": 455
      },
      "Index": 0
    },
    {
      "CompanyId": 615,
      "CompanyName": "ACT HIRE 2020 US",
      "AlphaCode": "ACT HIRE 2",
      "ApAccount": "223",
      "CreditStatus": "Credit",
      "Location": "0",
      "FinancialCompanyCode": "02",
      "CompanyType": "GEN",
      "Phone": "6582999231",
      "Client": false,
      "Supplier": true,
      "Subcontractor": false,
      "Other": true,
      "Inactive": false,
      "Select": {
        "CellId": "615",
        "CellValue": "ACT HIRE 2020 US",
        "CellTag": "ACT HIRE 2020 US"
      },
      "CompanyNameValue": {
        "CellId": "PopupDialog",
        "CellValue": "ACT HIRE 2020 US",
        "CellTag": "openDialog(\"615\")"
      },
      "AlphaCodeValue": {
        "CellValue": "ACT HIRE 2"
      },
      "ApAccountValue": {
        "CellValue": "223"
      },
      "ArAccountValue": {},
      "CreditStatusValue": {
        "CellValue": "Credit"
      },
      "LocationValue": {
        "CellId": "0",
        "CellValue": "0 : Head Office - Civil company"
      },
      "FinancialCompanyCodeValue": {
        "CellId": "02",
        "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)"
      },
      "CompanyTypeValue": {
        "CellId": "GEN",
        "CellValue": "GEN : General"
      },
      "PhoneValue": {
        "CellValue": "6582999231"
      },
      "CostValue": {
        "CellNumValue": 0
      },
      "CatalogueValue": {},
      "UpdatedDate": "2023-04-19T01:19:51.4653571+00:00",
      "OriginalKey": {
        "CompanyId": 615
      },
      "CurrentKey": {
        "CompanyId": 615
      },
      "Key": {
        "CompanyId": 615
      },
      "Index": 0
    }
  ]
}

Create a new company.

Expand

title	Click to view

Request

Code Block

language	json

{
    "Key": {
        "CompanyId": 0
    },
    "Main": {
    "CompanyName": {
        "StringValue": "FromAPI"
    },
    "AlphaCode": {
        "StringValue": "AG01"
    },
    "CompanyType": {
        "SelectedValue": "DEV"
    },
    "PriceCode": {
        "SelectedValue": "NZ"
    },
    "Location": {
        "SelectedValue": "AK"
    },
    "FinancialCompany": {
        "SelectedValue": "NZ"
    },
    "ArAccount": {
        "StringValue": "01"
    },
    "ApAccount": {
        "StringValue": "02"
    },
    "Currency": {
        "SelectedValue": "NZD"
    },
    "InactiveCompany": {
        "BoolValue": false
    },
    "Client": {
        "BoolValue": false
    },
    "Supplier": {
        "BoolValue": false
    },
    "Subcontractor": {
        "BoolValue": false
    },
    "Other": {
        "BoolValue": false
    },
    "GSTNumber": {
        "StringValue": ""
    },
    "DefaultJobManager": {
        "SelectedValue": null
    },
    "DefaultAccountManager": {
        "SelectedValue": null
    }
    },
    "Financials": {
    "PaymentTerms": {
        "DecimalValue": 5
    },
    "PaymentTermsType": {
        "SelectedValue": "1",
        "DropdownList": {
        "1": "Days from invoice date",
        "2": "Day of the following month",
        "3": "Last day of the following month",
        "4": "Days after end of this month",
        "": "Select..."
        }
    },
    "CreditStatus": {
        "SelectedValue": "Credit",
        "DropdownList": {
        "": "Select...",
        "Credit": "Credit",
        "Cash": "Cash",
        "Overdue": "Overdue",
        "Stop Credit": "Stop Credit"
        }
    },
    "CashLimit": {
        "DecimalValue": 10000
    },
    "BankAccountRef1": {
        "StringValue": ""
    },
    "BankAccountRef2": {
        "StringValue": ""
    },
    "BankAccountRef3": {
        "StringValue": ""
    },
    "UseGST": {
        "BoolValue": false
    },
    "CashOnly": {
        "BoolValue": true
    },
    "UseBuyerCreatedInvoices": {
        "BoolValue": false
    }
    },
    "Attributes": {
    "Rows": []
    },
    "CompanyInsurance": {
    "Rows": []
    },
    "Addresses": {
    "Rows": [
        {
        "Inactive": false,
        "IsPostalAddress": true,
        "IsPhysicalAddress": true,
        "NameValue": {
            "CellValue": "Name"
        },
        "Line1Value": {
            "CellValue": "Line1"
        },
        "Line2Value": {
            "CellValue": "Line2"
        },
        "PhoneValue": {
            "CellValue": "Phone"
        },
        "PostCodeValue": {
            "CellValue": "Post Code"
        },
        "Changed": false,
        "OriginalKey": {
            "AddressId": 0
        },
        "CurrentKey": {
            "AddressId": 0
        },
        "Key": {
            "AddressId": 0
        },
        "IsNew": true,
        "Index": 1
        }
    ]
    }
}

Response

Code Block

language	json

Response sample

Code Block

language	json

⬆️ Back to top

On this page

Table of Contents

minLevel	1
maxLevel	3
outline	false
type	list
separator	brackets
printable	false

Include Page

	KB1:How-to footer
	KB1:How-to footer

Versions Compared

Old Version 15

New Version 16

Key

Overview

Endpoints

CompanyListApi

CompanyDetailApi

Models

CompanyKey

CompanyLine

CompanyApiModel

CompanyMainFields

CompanyFinancialsFields

PersonLine

Examples

Get list of first 20 companies.

Request

Response

Response sample

Get the list of all Workbench companies.

Request

Response

Response sample

Create a new company.

Request

Response

Response sample

Page Comparison

Versions Compared

Old Version 15

New Version 16

Key

Overview

Endpoints

CompanyListApi

CompanyDetailApi

Models

CompanyKey

CompanyLine

CompanyApiModel

CompanyMainFields

CompanyFinancialsFields

PersonLine

Examples

Get list of first 20 companies.

Request

Response

Response sample

Get the list of all Workbench companies.

Request

Response

Response sample

Create a new company.

Request

Response

Response sample