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 | 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 |