Changes

Creating SmartConnect Functions

121 bytes added, 18:30, 6 September 2018

no edit summary

'''Action Type '''  -  Query<br />

'''Field List'''  - 

 

'''Mandatory field''':<br/>

'''reportid''' - is the [[Determining the reportid|Report ID]] of the [[Report|report]] in the instance.<br/>

'''Optional field'''<br/>

'''criteriavalue''' - when the [[Report|report]] has [[Setting_Text_Criteria_–_Logical_Operators_in_a_Report|text criteria]], values for the criteria(s) should be indicated in this field. If report contains multiple criteria, values should be delimited by double semi-colon eg. "VALUE_1;;VALUE_2".

=====A report query on the number of assessors grouped by specialty=====

criteriavalue: <br />

--End custom parameter--

 

[[File:APIFunctionReport3.PNG|800px]]

=====A report query on a list of Grants grouped by Focus Area=====

===List===

This function will retrieve a list of records from the selected '''Object Type'''. Records will include all fields from the '''Field List'''  and can be filtered using the parameter '''criteria''' and can also be sorted out using the parameter '''sortby'''.If the custom field has a predefined options, use '''getstorevalue'''  to show either the display value (getstorevalue: 0)  or to show the stored value (getstorevalue: 1). List

====List====

=====Retrieve a list of contacts=====

'''Function Name'''  -  3.03.1.1 List Method Sample 1: Retrieve a list of Contacts<br />

objectid - is the [[Determining_the_companyid|Company ID]] where the file is attached to.<br/>

fieldid - [[Custom_Field_ID|Custom Field ID]] of the Organization record that is either a [[Custom_Field_Type:_Upload_-_Single_File_Storage|single file type]] or [[Custom_Field_Type:_Upload_-_Multiple_Files_Storage|multiple file type]].

 

--Begin custom parameter --<br />

filename: Test.txt<br />

• ← Older edit
• Newer edit →

Lalaine Songalia

Smartstaff

1,385

edits