remote
Array
getByQuery
(
string
contactid,
string
companyid,
string
contact_first_name,
string
contact_last_name,
string
company_name,
string
company_town,
string
company_country,
string
company_state,
string
company_council,
string
company_postcode,
string
company_address,
string
company_role,
string
company_rolegroup,
numeric
project_value_min,
numeric
project_value_max,
string
project_name,
string
project_type,
numeric
projectid,
numeric
projectrefid,
string
project_keyword,
string
project_country,
string
project_state,
string
project_region,
string
project_council,
string
project_town,
string
project_category,
string
project_subcategory,
string
project_status,
string
project_stage,
string
project_date_stamp_min,
string
project_date_stamp_max,
numeric
company_tender_status,
string
project_postcode,
string
fields="",
required string
token
numeric
NumberOfRows="1000",
numeric
StartRow="1",
string
contact_timestamp_from,
string
contact_timestamp_to,
numeric
contact_timestamp
)
Output: Array
Parameters:
contactid: |
string, optional - ID of the contact
|
companyid: |
string, optional - ID of the company
|
contact_first_name: |
string, optional - First name of the contact
|
contact_last_name: |
string, optional - Last name of the contact
|
fields: |
string, optional - Field names of returned data - CONTACTID, FIRST_NAME, LAST_NAME, SALUTATION, POSITION, TELEPHONE, FAX, SITE_PHONE, MOBILE, EMAIL, COMPANYID, NOTE, TIME_STAMP, RESIGNED
|
token: |
string, required - allocated token for current login session
| company_name: |
string, optional - Partial or complete name of the company
|
company_town: |
string, optional - Town/suburb of the company
|
company_country: |
string, optional - ID or comma-seperated list of Country IDs
|
company_state: |
string, optional - ID or comma-seperated list of State IDs
|
company_council: |
string, optional - Name of the council
|
company_postcode: |
string, optional - Postcode of location of the company/contact
|
company_address: |
string, optional - Address of location of the company/contact
|
company_role: |
string, optional - ID or comma-seperated list of role IDs
|
company_rolegroup: |
string, optional - ID or comma-seperated list of role group IDs
|
project_value_min: |
numeric, optional - Minimum project value (in millions)
|
project_value_max: |
numeric, optional - Maximum project value (in millions)
|
project_name: |
string, optional - Partial or full project name
|
project_type: |
string, optional - Partial or full project type
|
projectid: |
numeric, optional - ID or comma-seperated list of project IDs
|
projectrefid: |
numeric, optional - ID or comma-seperated list of project Ref IDs
|
project_keyword: |
string, optional - Project keyword
|
project_country: |
string, optional - ID or comma-seperated list of countries where project is located
|
project_state: |
string, optional - ID or comma-seperated list of states where project is located
|
project_region: |
string, optional - ID or comma-seperated list of BCI Regions where project is located
|
project_council: |
string, optional - Name of council where project is located
|
project_town: |
string, optional - Name of town/suburb where project is located
|
project_category: |
string, optional - ID or comma-seperated list of categories of projects
|
project_subcategory: |
string, optional - ID or comma-seperated list of sub categories of projects
|
project_status: |
string, optional - ID or comma-seperated list of statuses of projects
|
project_stage: |
string, optional - ID or comma-seperated list of stages of projects
|
project_date_stamp_min: |
string, optional - Minimum date of project published date, accepted datetime format (dd/mm/yyyy or dd/mm/yyyy HH:mi where dd represents 2 digit dates, mm represents 2 digit month, yyyy is 4 digits for year, HH represents 2 digit hours according to a 24-hr clock, mi represents 2 digits minutes)
|
project_date_stamp_max: |
string, optional - Maximum date of project published date, accepted datetime format (dd/mm/yyyy or dd/mm/yyyy HH:mi where dd represents 2 digit dates, mm represents 2 digit month, yyyy is 4 digits for year, HH represents 2 digit hours according to a 24-hr clock, mi represents 2 digits minutes)
|
company_tender_status: |
numeric, optional - tender Status
|
project_postcode: |
string, optional - Postcode where project is located
|
NumberOfRows: |
numeric, optional - Number of result records being requested
|
StartRow: |
numeric, optional - Start position of the recordset being requested, default is 1
|
contact_timestamp_from: |
string, optional - Minimum date stamp for searching using a time frame, accepted datetime format (dd/mm/yyyy or dd/mm/yyyy HH:mi where dd represents 2 digit dates, mm represents 2 digit month, yyyy is 4 digits for year, HH represents 2 digit hours according to a 24-hr clock, mi represents 2 digits minutes)
|
contact_timestamp_to: |
string, optional - Maximum date stamp for searching using a time frame, accepted datetime format (dd/mm/yyyy or dd/mm/yyyy HH:mi where dd represents 2 digit dates, mm represents 2 digit month, yyyy is 4 digits for year, HH represents 2 digit hours according to a 24-hr clock, mi represents 2 digits minutes)
|
contact_timestamp: |
numeric, optional - Number of days relative to today as a time-frame, for example 5 means searching through last 5 days. This considers the exact time so timestamp=1 effectively means contacts updated in the last 24 hours, timestamp=2 would mean contacts updated in the last 48 hours.
|
Fields |
Selectable fields for contact information
|
CONTACTID | LONG |
FIRST_NAME | STRING(1000) |
LAST_NAME | STRING(1000) |
NAME_ORDER | INTEGER |
SALUTATION | STRING(1000) |
POSITION | STRING(1000) |
TELEPHONE | STRING(1000) |
FAX | STRING(1000) |
SITE_PHONE | STRING(1000) |
MOBILE | STRING(1000) |
EMAIL | STRING(1000) |
COMPANYID | LONG |
NOTE | STRING(1000) |
TIME_STAMP | DATE |
RESIGNED | INTEGER |
COMPANY_NAME | STRING(1000) |
|
Sample Output - getByPK() - XML |
Mr
08 9999 9999
Smith
0.0
2012-10-03T12:49:57+10:00
454545
John
john@bhbconsulting.com.au
Structural Director
08 9999 9999
155555
|
|