'''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/>
'''Function Name''' - 3.03.1.2 List Method Sample 2: Retrieve a list of Organizations<br />
'''Description''' - To retrieve a list of organizations.
'''Object Type''' - Company<br />
'''Action Type ''' - List<br />
<u>'''Sample 2B'''</u><br/>
'''Description''' - To retrieve a list of organizations with organization name that starts with "Br" and address that contains "Ave" with an the list in ascending order based on the organization name.<br />
--Begin custom parameter --<br />
criteria : [{"andor":"and","field":"sf_Name","operator":"like","value":"Br%"},{"andor":"and","field":"sf_Address","operator":"like","value":"%Ave%"}]<br />
[https://api.smartsimple.com/API/1/report/?url=https://api.smartsimple.com/API/1/report/&companyid=825646&alias=api&username=dataimport@smartsimple.com&password=smartsimple1&apitoken=W0t2dV58fmZGR1lzUmVDc2xibnd8BEdfAgMBAg~~&filename=Test.txt&objectid=1688407&fieldid=1523157| Click here to download the file]
[[File:APIFunctionDownloadFile1.PNG|800px]]
===Search File===
====Search Files Method Sample 1: Search Case Documents====