| CORE_STRUCTURE_DATA_SEARCH | CORE Endpoint | |
| /ondemand/core/?method=CORE_STRUCTURE_DATA_SEARCH | ||
| As a note, this is not a standard Advanced Search. As such, the filtering available is different |
| AVAILABLE FILTERS | TYPE | ||
| completedby | Numeric | Id of the User who completed the Survey | |
| contactperson | Numeric | Id of the Contact the Survey is linked to | |
| contactpersonrelationshipmanager | Numeric | Id of the Relationship Manager of the Contact the Survey is linked to | |
| contactpersonstate | Text | State (eg NSW) of the Contact Survey is linked to | |
| endDate | Date | Results last updated on or before this date will be displayed | |
| id | Numeric | Id of the Result | |
| lockedDateFrom | Date | Results Locked on or after this date will be displayed | |
| lockedDateTo | Date | Results Locked on or before this date will be displayed | |
| object | Numeric | Type of object the survey is linked to. Click here to see the full list | |
| objectcontext | Numeric | Id of Linked Object | |
| referenceDateFrom | Date | Results with a Reference Date on or after this date will be displayed | |
| referenceDateTo | Date | Results with a Reference Date on or before this date will be displayed | |
| status | Numeric | Comma Delimited list of Status Ids. 1=In Progress,2=Completed,3=Cancelled,4=Locked | |
| startDate | Date | Results last updated on or after this date will be displayed | |
| survey | Numeric | Id of the survey |
| AVAILABLE OPTIONS | TYPE | ||
| startrow | Numeric | First Row to Display. 1 is the first row | |
| rows | Numeric | Number of rows to be returned |
| AVAILABLE FIELDS | TYPE | All the fields are automatically returned, except where noted | |
| completedby | Numeric | ||
| completeddate | Date | Date Result was last marked as Completed. Only returned if ReturnStatusChangeDates=1 is passed | |
| contactbusinesstext | Text | Business Name of the Contact | |
| contactpersonid | Numeric | ||
| contactpersonrelationshipmanager | Numeric | ||
| contactpersonrelationshipmanagertext | Text | ||
| contactpersonstate | Text | State (eg NSW) of the Contact that the Survey is linked to | |
| contactpersontext | Text | Name of the Contact that the Survey is linked to | |
| id | Numeric | Result Id | |
| inprogressdate | Date | Date Result was last marked as In Progress. Only returned if ReturnStatusChangeDates=1 is passed | |
| issuescreated | Text | Y/N | |
| lastmodifieddate | Date | ||
| lastmodifieddatetime | Date | Date & Time | |
| lockeddate | Date | Date Result was last marked as Locked. Only returned if ReturnStatusChangeDates=1 is passed | |
| notes | Text | ||
| reference | Text | Result Reference | |
| referencedate | Date | ||
| referencetype | Text | You specify your own when creating the Survey / Structure | |
| resultscore | Numeric | ||
| rownumber | Numeric | ||
| scheduledcompletedate | Date | ||
| scheduledcompletedatetime | Date | ||
| status | Numeric | 1=In Progress,2=Completed,3=Cancelled,4=Locked | |
| totalpoints | Numeric |
| ANSWER FIELDS | TYPE | If you pass ReturnAnswers=1, the answers are also returned. You need to be careful about the volume of data that this may attempt to return | |
| sq | Varies | ||
| sqtext | Varies |
| EXAMPLE | |
| 1. Return all results for Survey 123 that were last modified between 1st Jan 2011 and Star Wars Day 2011. Return in json format | |
| /ondemand/core/core.asp?method=CORE_SURVEY_RESULT_SEARCH&survey=123&startDate=01+Jan+2011&endDate=04+May+2011&rf=json |