Skip to main content
Property IQ API
SLINKY avatar
Written by SLINKY
Updated over 4 months ago

Set-Up

The Property IQ API requires authentication between STAFFLINK and Property IQ. Please allow up to two weeks for set up to be performed. Contact your Customer Success Manager to implement this.

If there are multiple Property IQ accounts, they can all be fed into the same base, or separate bases if that is preferred, each account will need to be authenticated one by one.

Once implemented, please do not change the names of any tables used by the API. Consequently, please also do not change any of the fields that the API feeds data into for each record. If you change data in any of the fields, the API will also overwrite it on the next run.

Not all data is available from Property IQ, only selected data that is provided by the Property IQ API.

The following jobs run to syncronise data.

Lots

The Lots job feeds Lots from Property IQ. The job runs once a day and updates data from all lots.

Fields For Lots Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record Id

Text

The lot plan

SPlan

Text

The name of the building

Building Name

Text

The unit number

Unit Number

Number

The full address

Address

Text

The lot number

Lot Number

Number

The name of the owner

Name

Text

Salutation of the owner

Salutation

Text

Contact person for the unit

Contact

Text

First phone number

Phone1

Text

Second phone number

Phone2

Text

Owner fax number

Fax

Text

Owner mobile number

Mobile

Text

Owner email

Email

Text

Unit of entitlement

Unit Of Entitlement

Number

Second unit of entitlement

Unit Of Entitlement 2

Number

When they are paid to in levies

Paid To Date

Date

Last sold date

Last Settled Date

Date

Are they a committee member

Committee Member

Checkbox

CMR

CMR

Checkbox

Accessory unit number

Accessory Unit

Number

Is it an OO

Owner Occupier

Checkbox

Has legal action?

Legal Action

Checkbox

Has repayment plan?

Repayment Plan

Checkbox

Post levy notice?

Post Levy Notice

Checkbox

Email levy notice?

Email Levy Notice

Checkbox

Post general correspondence?

Post General Correspondence

Checkbox

Email general correspondence?

Email General Correspondence

Checkbox

Post annual notice?

Post Annual Notice

Checkbox

Email annual notice?

Email Annual Notice

Checkbox

Post utility notice?

Post Utility Notice

Checkbox

Email utility notice?

Email Utility Notice

Checkbox

Property manager

Agent

Single Select

Attourney

Attourney

Text

Who receives correspondence notice

Correspondence Notice Receiver

Text

Who is the joint owner

Joint Owner

Text

Who receives levy notice

Levy Notice Receiver

Text

Who is the manager

Manager

Single Select

Who is the tenant

Tenant

Text

Who receives utility notices

Utility Notice Receivers

Text

What is the owner contact

Owner Contact

Text

Who are the mortagees

Mortagees

Text

Who are the nominees

Nominees

Text

Buildings

The Buildings job feeds Buildings from Property IQ. The job runs once a day and updates data from all buildings.

Fields For Building Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record Id

Text

Plan of the building

SPlan

Text

Building name

Building Name

Text

Building address

Address

Text

ABN

ABN

Number

ACN

ACN

Number

TFN

TFN

Number

Units of Entitlement

Total UOE

Number

Building Sub Type

Building Sub Type

Single Select

Sub Type

Sub Type

Single Select

Additional Type

Additional Type

Single Select

Is all inclusive?

All Inclusive

Checkbox

Is interest charged?

Charge Interest

Checkbox

Is there a tax return?

Tax Return

Checkbox

Management Fee

Management Fee

Currency

Management Fee Frequency

Management Fee Frequency

Single Select

Audit accounts?

Audit Accounts

Checkbox

When does financial year start

Financial Year Start

Date

When does levy year start

Levy Year Start

Date

How often are levies

Levy Frequency

Date

When next AGM

Next AGM

Date

When was the building registered

Registered Date

Date

When was the building acquired

Date Acquired

Date

When was the building lost

Date Resigned

Date

When was the building valued

Date Revalued

Date

When was the agreement date

Agreement Date

Date

Is it GST Registered

GST Registered

Checkbox

How often is BAS done

BAS Frequency

Single Select

What is the Parish of the building

Parish

Text

What is the County of the building

County

Text

What is the strata module

Module

Text

What is the strata class

Class

Text

What is the building plan

Plan

Text

What is the strata regulation

Regulation

Text

Is the building an active management

Active

Checkbox

What was the building insurance val

Insurance Valuation

Currency

Is electronic voting approved

Electronic Voting Approved

Checkbox

What is the resolution date for this

Electronic Voting Resolution Date

Date

What was the meeting quorum

Meeting Quorum

Date

What is the resolution date for this

Meeting Quorum Resolution Date

Date

What is the balance of the sinking fund

Sinking Fund Balance

Currency

Balance of the admin fund

Admin Fund Balance

Currency

Balance of all funds

Total Fund Balance

Currency

Investment

Investment Accounts

Text

Bank account numbers

Bank Account

Text

Original Proprietor

Original Proprietor

Text

Folio Number

Folio Number

Number

Folio Name

Folio Name

Text

Sundries amount

Sundries

Currency

Committee member list

Committee Members

Multiple Select

Schedules

The Schedules job feeds Schedules from Property IQ. The job runs once a day and updates data from all schedules.

Fields For Schedules Table

Property IQ Data

Field Name

Field Type

The name of the schedule

Name

Text

The limit of the admin balance

Admin_Balance_Limit

Currency

The building Id

Building_Id

Number

The limit of the sinking balance

Sinking_Balance_Limit

Currency

The limit of all fund balance

Total_Balance_Limit

Currency

Internal Property IQ Id

Record_Id

Text

Insurance

The Insurance job feeds Insurance coverage from Property IQ. The job runs once a week and updates data from insurance premiums updated since last run.

Fields For Insurance Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record_Id

Text

The policy number

Policy_Number

Text

The building id

Building_Id

Text

The date of expiry

Expiry_Date

Date

The date it was paid

Paid_Date

Date

The premium amount

Premium

Currency

The amount covered

Cover

Currency

Insurance broker name

Broker

Text

Insurer company

Insurer

Text

Folios

The Folios job feeds Folio data from Property IQ. The job runs once a week and updates data from insurance premiums updated since last run.

Fields For Folios Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record_Id

Text

The name of the folio

Name

Text

The name of the company

Company

Text

Lot Ledgers

The Lot Ledgers job feeds Lot Ledger data from Property IQ. The job runs once a week and updates data from insurance premiums updated since last run.

Fields For LotLedgers Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record_Id

Text

The total amount due

Total_Due

Currency

The total admin amount due

Admin_Due

Currency

The total sinking amount due

Sinking_Due

Currency

The total amount paid

Total_Paid

Currency

The total admin amount paid

Admin_Paid

Currency

The total sinking amount paid

Sinking_Paid

Currency

The total amount net

Total_Nett

Currency

The total admin amount net

Admin_Nett

Currency

The total sinking amount net

Sinking_Nett

Currency

Total interest amount due

Total_Interest_Due

Currency

Total admin interest amount due

Admin_Interest_Due

Currency

Total sinking interest amount due

Sinking_Interest_Due

Currency

Total interest amount paid

Sinking_Interest_Paid

Currency

Total interest amount waived

Total_Interest_Waived

Currency

Total admin interest amount waived

Admin_Interest_Waived

Currency

Total sinking interest amount waived

Sinking_Interest_Waived

Currency

Total discount given

Total_Discount

Currency

Admin discoiunt given

Admin_Discount

Currency

Sinking discount given

Sinking_Discount

Currency

The balance owed

Balance

Currency

Lot Alerts

The Lot Alerts job feeds Alert data from Property IQ. The job runs once a week and updates data from insurance premiums updated since last run.

Fields For LotAlerts Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record_Id

Text

The building plan

SPlan

Text

The lot number

Lot_Number

Number

The alert

Alert

Text

When the alert was created

Created

Date

When the alert was updated

Updated

Date

Is the alert active

Active

Checkbox

Arrears

The Arrears job feeds Arrear data from Property IQ. The job runs once a week and updates all data. Uses the overdue levies table.

Fields For Overdue Levies Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record_Id

Text

The building plan

SPlan

Text

The address of the lot

Address

Text

The owner's name

Owner_Name

Text

The date the levy was due

Levy_Date

Date

The details of the levy

Levy_Details

Text

What is overdue

Levy_Outstanding

Currency

How much interest accrued

Levy_Interest

Currency

Is it archived

Archived

Checkbox

Invoices

The Invoices job feeds Invoice data from Property IQ. The job runs every 12 hours and updates data from last run

Fields For Invoices Table

Property IQ Data

Field Name

Field Type

Internal Property IQ Id

Record_Id

Text

Supplier Id

Supplier_Id

Text

Building Id

Building_Id

Text

Work order Id

Work_Order_Id

Text

User Id approved

Approving_User_Id

Text

Date of transaction

Transaction_Date

Date

Due date of invoice

Due_Date

Date

Reference of invoice

Reference

Text

Customer reference number

CRN

Text

Amount of invoice

Total_Amount_Inc_GST

Currency

Has approval

Approval

Checkbox

Has external approval

External_Approval

Checkbox

Invoice line items

Line_Items

Text

Linking Jobs

Linking jobs link data between tables. There are four fields that are involved, two ID fields and two link fields. The API will match records based on the ID fields and link the data using the corresponding link fields for that record. The following links are available, defined by the link between Table A and (->) Table B. Linking threads run every five hours.

Buildings -> Lots

Data

Field Name

Field Type

Id of Table A

SPlan

Text

Id of Table B

SPlan

Text

Link in Table A

Building

Link

Link in Table B

Lot

Link

Lots -> Overdue Levies

Data

Field Name

Field Type

Id of Table A

Lot Identifier

Text

Id of Table B

Lot Identifier

Text

Link in Table A

Lots

Link

Link in Table B

Overdue Levies

Link

Lots -> LotAlerts

Data

Field Name

Field Type

Id of Table A

Lot Identifier

Text

Id of Table B

Lot Identifier

Text

Link in Table A

Lots

Link

Link in Table B

LotAlerts

Link

Buildings -> Overdue Levies

Data

Field Name

Field Type

Id of Table A

SPlan

Text

Id of Table B

SPlan

Text

Link in Table A

Buildings

Link

Link in Table B

Overdue Levies

Link

Buildings -> Invoices

Data

Field Name

Field Type

Id of Table A

Record Id

Text

Id of Table B

Building Id

Text

Link in Table A

Buildings

Link

Link in Table B

Invoices

Link

Buildings -> Insurances

Data

Field Name

Field Type

Id of Table A

Record Id

Text

Id of Table B

Building Id

Text

Link in Table A

Buildings

Link

Link in Table B

Insurances

Link

Buildings -> Schedules

Data

Field Name

Field Type

Id of Table A

Record Id

Text

Id of Table B

Building Id

Text

Link in Table A

Buildings

Link

Link in Table B

Schedules

Link

Did this answer your question?