DataFlex / Creatio API / $filter parameter with startswith function
Back to Collection Items
Use ChilkatAx-9.5.0-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Variant vQueryParams
Handle hoQueryParams
Variant vResp
Handle hoResp
Variant vSbResponseBody
Handle hoSbResponseBody
Handle hoXmlResponse
String sCategory_term
String sCategory_scheme
Integer j
Integer iCount_j
String sLink_type
String sContent_type
String sD_Id_m_type
String sD_Id
String sD_Name
String sD_CreatedOn_m_type
String sD_CreatedOn
String sD_CreatedById_m_type
String sD_CreatedById
String sD_ModifiedOn_m_type
String sD_ModifiedOn
String sD_ModifiedById_m_type
String sD_ModifiedById
String sD_ProcessListeners_m_type
Integer iD_ProcessListeners
String sD_ContactId_m_type
String sD_ContactId
String sD_OrgStructureUnitId_m_type
String sD_OrgStructureUnitId
String sD_JobId_m_type
String sD_JobId
String sD_FullJobTitle
String sD_OwnerId_m_type
String sD_OwnerId
String sD_CareerStartDate_m_type
String sD_CareerStartDate
String sD_CareerDueDate_m_type
String sD_CareerDueDate
String sD_ProbationDueDate_m_type
String sD_ProbationDueDate
String sD_ReasonForDismissalId_m_type
String sD_ReasonForDismissalId
String sD_AccountId_m_type
String sD_AccountId
String sD_ManagerId_m_type
String sD_ManagerId
String sFeed_xml_base
String sFeed_xmlns
String sFeed_xmlns_d
String sFeed_xmlns_m
String sId
String sTitle_type
String sTitle
String sUpdated
String sLink_rel
String sLink_title
String sLink_href
Integer i
Integer iCount_i
String sTemp1
Boolean bTemp1
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
Get Create (RefClass(cComChilkatJsonObject)) To hoQueryParams
If (Not(IsComObjectCreated(hoQueryParams))) Begin
Send CreateComObject of hoQueryParams
End
Get ComUpdateString Of hoQueryParams "$filter" "startswith(Field2,'Field2Value')" To iSuccess
Send ComSetRequestHeader To hoHttp "ForceUseSession" "true"
Send ComSetRequestHeader To hoHttp "BPMCSRF" "{{BPMCSRF}}"
Get pvComObject of hoQueryParams to vQueryParams
Get ComQuickRequestParams Of hoHttp "GET" "https://myserver.com/0/ServiceModel/EntityDataService.svc/Collection1Collection" vQueryParams To vResp
If (IsComObject(vResp)) Begin
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
Set pvComObject Of hoResp To vResp
End
Get ComLastMethodSuccess Of hoHttp To bTemp1
If (bTemp1 = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComGetBodySb Of hoResp vSbResponseBody To iSuccess
Send Destroy of hoResp
Get Create (RefClass(cComChilkatXml)) To hoXmlResponse
If (Not(IsComObjectCreated(hoXmlResponse))) Begin
Send CreateComObject of hoXmlResponse
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoXmlResponse vSbResponseBody True To iSuccess
Get ComGetXml Of hoXmlResponse To sTemp1
Showln sTemp1
// Sample XML response:
// (Sample code for parsing the XML response is shown below)
// <?xml version="1.0" encoding="utf-8"?>
// <feed xml:base="https://myserver.com/0/ServiceModel/EntityDataService.svc/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
// <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection</id>
// <title type="text">EmployeeCollection</title>
// <updated>2020-04-09T11:25:13Z</updated>
// <link rel="self" title="EmployeeCollection" href="EmployeeCollection"/>
// <entry>
// <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')</id>
// <category term="Terrasoft.Configuration.Employee" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/>
// <link rel="edit" title="Employee" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy" type="application/atom+xml;type=entry" title="CreatedBy" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/CreatedBy"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/ModifiedBy"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Contact" type="application/atom+xml;type=entry" title="Contact" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Contact"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnitCollectionByHead" type="application/atom+xml;type=feed" title="OrgStructureUnitCollectionByHead" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/OrgStructureUnitCollectionByHead"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnit" type="application/atom+xml;type=entry" title="OrgStructureUnit" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/OrgStructureUnit"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Job" type="application/atom+xml;type=entry" title="Job" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Job"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner" type="application/atom+xml;type=entry" title="Owner" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Owner"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ReasonForDismissal" type="application/atom+xml;type=entry" title="ReasonForDismissal" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/ReasonForDismissal"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Account" type="application/atom+xml;type=entry" title="Account" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Account"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Manager" type="application/atom+xml;type=entry" title="Manager" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Manager"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByManager" type="application/atom+xml;type=feed" title="EmployeeCollectionByManager" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeCollectionByManager"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeCareerCollectionByEmployee" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeCareerCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeFileCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeFileCollectionByEmployee" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeFileCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInFolderCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeInFolderCollectionByEmployee" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeInFolderCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInTagCollectionByEntity" type="application/atom+xml;type=feed" title="EmployeeInTagCollectionByEntity" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeInTagCollectionByEntity"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SalaryCollectionByEmployee" type="application/atom+xml;type=feed" title="SalaryCollectionByEmployee" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/SalaryCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwEmployeesHierarchyCollectionByEmployee" type="application/atom+xml;type=feed" title="VwEmployeesHierarchyCollectionByEmployee" href="EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/VwEmployeesHierarchyCollectionByEmployee"/>
// <title/>
// <updated>2020-04-09T11:25:13Z</updated>
// <author>
// <name/>
// </author>
// <content type="application/xml">
// <m:properties>
// <d:Id m:type="Edm.Guid">9842387d-069f-466c-9551-32cedbc16d90</d:Id>
// <d:Name>Mary King</d:Name>
// <d:CreatedOn m:type="Edm.DateTime">2017-03-30T14:50:30Z</d:CreatedOn>
// <d:CreatedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>
// <d:ModifiedOn m:type="Edm.DateTime">2017-03-31T07:27:18Z</d:ModifiedOn>
// <d:ModifiedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:ModifiedById>
// <d:ProcessListeners m:type="Edm.Int32">0</d:ProcessListeners>
// <d:ContactId m:type="Edm.Guid">cad50d15-f28d-49fc-aa79-21615ac35b86</d:ContactId>
// <d:OrgStructureUnitId m:type="Edm.Guid">43172897-fbd6-4bc1-b81b-55964ab558e6</d:OrgStructureUnitId>
// <d:Notes/>
// <d:JobId m:type="Edm.Guid">955472f0-56e6-df11-971b-001d60e938c6</d:JobId>
// <d:FullJobTitle>Customer manager</d:FullJobTitle>
// <d:OwnerId m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:OwnerId>
// <d:CareerStartDate m:type="Edm.DateTime">2019-04-07T00:00:00</d:CareerStartDate>
// <d:CareerDueDate m:type="Edm.DateTime">0001-01-01T00:00:00</d:CareerDueDate>
// <d:ProbationDueDate m:type="Edm.DateTime">0001-01-01T00:00:00</d:ProbationDueDate>
// <d:ReasonForDismissalId m:type="Edm.Guid">00000000-0000-0000-0000-000000000000</d:ReasonForDismissalId>
// <d:AccountId m:type="Edm.Guid">e308b781-3c5b-4ecb-89ef-5c1ed4da488e</d:AccountId>
// <d:ManagerId m:type="Edm.Guid">e17c9cd6-262d-481d-86a9-f09a82984e0e</d:ManagerId>
// </m:properties>
// </content>
// </entry>
// <entry>
// <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')</id>
// <category term="Terrasoft.Configuration.Employee" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/>
// <link rel="edit" title="Employee" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy" type="application/atom+xml;type=entry" title="CreatedBy" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/CreatedBy"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/ModifiedBy"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Contact" type="application/atom+xml;type=entry" title="Contact" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Contact"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnitCollectionByHead" type="application/atom+xml;type=feed" title="OrgStructureUnitCollectionByHead" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/OrgStructureUnitCollectionByHead"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnit" type="application/atom+xml;type=entry" title="OrgStructureUnit" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/OrgStructureUnit"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Job" type="application/atom+xml;type=entry" title="Job" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Job"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner" type="application/atom+xml;type=entry" title="Owner" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Owner"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ReasonForDismissal" type="application/atom+xml;type=entry" title="ReasonForDismissal" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/ReasonForDismissal"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Account" type="application/atom+xml;type=entry" title="Account" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Account"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Manager" type="application/atom+xml;type=entry" title="Manager" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Manager"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByManager" type="application/atom+xml;type=feed" title="EmployeeCollectionByManager" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeCollectionByManager"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeCareerCollectionByEmployee" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeCareerCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeFileCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeFileCollectionByEmployee" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeFileCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInFolderCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeInFolderCollectionByEmployee" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeInFolderCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInTagCollectionByEntity" type="application/atom+xml;type=feed" title="EmployeeInTagCollectionByEntity" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeInTagCollectionByEntity"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SalaryCollectionByEmployee" type="application/atom+xml;type=feed" title="SalaryCollectionByEmployee" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/SalaryCollectionByEmployee"/>
// <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwEmployeesHierarchyCollectionByEmployee" type="application/atom+xml;type=feed" title="VwEmployeesHierarchyCollectionByEmployee" href="EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/VwEmployeesHierarchyCollectionByEmployee"/>
// <title/>
// <updated>2020-04-09T11:25:13Z</updated>
// <author>
// <name/>
// </author>
// <content type="application/xml">
// <m:properties>
// <d:Id m:type="Edm.Guid">3b952b60-2502-4ab2-a967-7f898f8b8b55</d:Id>
// <d:Name>Megan Lewis</d:Name>
// <d:CreatedOn m:type="Edm.DateTime">2017-03-30T14:51:27Z</d:CreatedOn>
// <d:CreatedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>
// <d:ModifiedOn m:type="Edm.DateTime">2017-03-31T07:30:20Z</d:ModifiedOn>
// <d:ModifiedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:ModifiedById>
// <d:ProcessListeners m:type="Edm.Int32">0</d:ProcessListeners>
// <d:ContactId m:type="Edm.Guid">27bbc601-2d48-4652-8d18-eb93e718a78c</d:ContactId>
// <d:OrgStructureUnitId m:type="Edm.Guid">43172897-fbd6-4bc1-b81b-55964ab558e6</d:OrgStructureUnitId>
// <d:Notes/>
// <d:JobId m:type="Edm.Guid">955472f0-56e6-df11-971b-001d60e938c6</d:JobId>
// <d:FullJobTitle>Customer manager</d:FullJobTitle>
// <d:OwnerId m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:OwnerId>
// <d:CareerStartDate m:type="Edm.DateTime">2019-11-10T00:00:00</d:CareerStartDate>
// <d:CareerDueDate m:type="Edm.DateTime">0001-01-01T00:00:00</d:CareerDueDate>
// <d:ProbationDueDate m:type="Edm.DateTime">2020-02-10T00:00:00</d:ProbationDueDate>
// <d:ReasonForDismissalId m:type="Edm.Guid">00000000-0000-0000-0000-000000000000</d:ReasonForDismissalId>
// <d:AccountId m:type="Edm.Guid">e308b781-3c5b-4ecb-89ef-5c1ed4da488e</d:AccountId>
// <d:ManagerId m:type="Edm.Guid">e17c9cd6-262d-481d-86a9-f09a82984e0e</d:ManagerId>
// </m:properties>
// </content>
// </entry>
// </feed>
// Sample code for parsing the XML response...
// Use this online tool to generate parsing code from sample XML: Generate XML Parsing Code
Get ComGetAttrValue Of hoXmlResponse "xml:base" To sFeed_xml_base
Get ComGetAttrValue Of hoXmlResponse "xmlns" To sFeed_xmlns
Get ComGetAttrValue Of hoXmlResponse "xmlns:d" To sFeed_xmlns_d
Get ComGetAttrValue Of hoXmlResponse "xmlns:m" To sFeed_xmlns_m
Get ComGetChildContent Of hoXmlResponse "id" To sId
Get ComChilkatPath Of hoXmlResponse "title|(type)" To sTitle_type
Get ComGetChildContent Of hoXmlResponse "title" To sTitle
Get ComGetChildContent Of hoXmlResponse "updated" To sUpdated
Get ComChilkatPath Of hoXmlResponse "link|(rel)" To sLink_rel
Get ComChilkatPath Of hoXmlResponse "link|(title)" To sLink_title
Get ComChilkatPath Of hoXmlResponse "link|(href)" To sLink_href
Move 0 To i
Get ComNumChildrenHavingTag Of hoXmlResponse "entry" To iCount_i
While (i < iCount_i)
Set ComI Of hoXmlResponse To i
Get ComGetChildContent Of hoXmlResponse "entry[i]|id" To sId
Get ComChilkatPath Of hoXmlResponse "entry[i]|category|(term)" To sCategory_term
Get ComChilkatPath Of hoXmlResponse "entry[i]|category|(scheme)" To sCategory_scheme
Move 0 To j
Get ComNumChildrenHavingTag Of hoXmlResponse "entry[i]|link" To iCount_j
While (j < iCount_j)
Set ComJ Of hoXmlResponse To j
Get ComChilkatPath Of hoXmlResponse "entry[i]|link[j]|(rel)" To sLink_rel
Get ComChilkatPath Of hoXmlResponse "entry[i]|link[j]|(title)" To sLink_title
Get ComChilkatPath Of hoXmlResponse "entry[i]|link[j]|(href)" To sLink_href
Get ComChilkatPath Of hoXmlResponse "entry[i]|link[j]|(type)" To sLink_type
Move (j + 1) To j
Loop
Get ComGetChildContent Of hoXmlResponse "entry[i]|updated" To sUpdated
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|(type)" To sContent_type
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:Id|(m:type)" To sD_Id_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:Id" To sD_Id
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:Name" To sD_Name
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:CreatedOn|(m:type)" To sD_CreatedOn_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:CreatedOn" To sD_CreatedOn
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:CreatedById|(m:type)" To sD_CreatedById_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:CreatedById" To sD_CreatedById
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ModifiedOn|(m:type)" To sD_ModifiedOn_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:ModifiedOn" To sD_ModifiedOn
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ModifiedById|(m:type)" To sD_ModifiedById_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:ModifiedById" To sD_ModifiedById
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ProcessListeners|(m:type)" To sD_ProcessListeners_m_type
Get ComGetChildIntValue Of hoXmlResponse "entry[i]|content|m:properties|d:ProcessListeners" To iD_ProcessListeners
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ContactId|(m:type)" To sD_ContactId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:ContactId" To sD_ContactId
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:OrgStructureUnitId|(m:type)" To sD_OrgStructureUnitId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:OrgStructureUnitId" To sD_OrgStructureUnitId
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:JobId|(m:type)" To sD_JobId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:JobId" To sD_JobId
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:FullJobTitle" To sD_FullJobTitle
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:OwnerId|(m:type)" To sD_OwnerId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:OwnerId" To sD_OwnerId
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:CareerStartDate|(m:type)" To sD_CareerStartDate_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:CareerStartDate" To sD_CareerStartDate
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:CareerDueDate|(m:type)" To sD_CareerDueDate_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:CareerDueDate" To sD_CareerDueDate
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ProbationDueDate|(m:type)" To sD_ProbationDueDate_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:ProbationDueDate" To sD_ProbationDueDate
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ReasonForDismissalId|(m:type)" To sD_ReasonForDismissalId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:ReasonForDismissalId" To sD_ReasonForDismissalId
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:AccountId|(m:type)" To sD_AccountId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:AccountId" To sD_AccountId
Get ComChilkatPath Of hoXmlResponse "entry[i]|content|m:properties|d:ManagerId|(m:type)" To sD_ManagerId_m_type
Get ComGetChildContent Of hoXmlResponse "entry[i]|content|m:properties|d:ManagerId" To sD_ManagerId
Move (i + 1) To i
Loop
End_Procedure
Curl Command
curl -G -d "$filter=startswith%28Field2,%27Field2Value%27%29"
-H "ForceUseSession: true"
-H "BPMCSRF: {{BPMCSRF}}"
https://myserver.com/0/ServiceModel/EntityDataService.svc/Collection1Collection
Postman Collection Item JSON
{
"name": "$filter parameter with startswith function",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "ForceUseSession",
"type": "text",
"value": "true"
},
{
"key": "BPMCSRF",
"type": "text",
"value": "{{BPMCSRF}}"
}
],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "{{BaseURI}}/0/ServiceModel/EntityDataService.svc/{{CollectionName1}}Collection?$filter=startswith({{FieldName2}},'{{FieldName2Value2}}')",
"host": [
"{{BaseURI}}"
],
"path": [
"0",
"ServiceModel",
"EntityDataService.svc",
"{{CollectionName1}}Collection"
],
"query": [
{
"key": "$filter",
"value": "startswith({{FieldName2}},'{{FieldName2Value2}}')"
}
]
},
"description": "Request for getting filtered object collection instances via the [$filter](https://www.odata.org/documentation/odata-version-3-0/odata-version-3-0-core-protocol/#thefiltersystemqueryoption) parameter with the startswith function."
},
"response": [
{
"name": "[200] Gets filtered object collection instances. The filter uses the “startswith” function",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "ForceUseSession",
"type": "text",
"value": "true"
},
{
"key": "BPMCSRF",
"type": "text",
"value": "{{BPMCSRF}}"
}
],
"url": {
"raw": "https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection?$filter=startswith(FullJobTitle,'Custom')",
"protocol": "https",
"host": [
"myserver",
"com"
],
"path": [
"0",
"ServiceModel",
"EntityDataService.svc",
"EmployeeCollection"
],
"query": [
{
"key": "$filter",
"value": "startswith(FullJobTitle,'Custom')"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "xml",
"header": [
{
"key": "Cache-Control",
"value": "no-cache"
},
{
"key": "Content-Type",
"value": "application/atom+xml;type=feed;charset=utf-8"
},
{
"key": "Server",
"value": "Microsoft-IIS/10.0"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "DataServiceVersion",
"value": "2.0;"
},
{
"key": "X-AspNet-Version",
"value": "4.0.30319"
},
{
"key": "X-Powered-By",
"value": "ASP.NET"
},
{
"key": "X-Frame-Options",
"value": "SAMEORIGIN"
},
{
"key": "Date",
"value": "Thu, 09 Apr 2020 11:25:13 GMT"
},
{
"key": "Content-Length",
"value": "12987"
}
],
"cookie": [
],
"body": "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<feed xml:base=\"https://myserver.com/0/ServiceModel/EntityDataService.svc/\" xmlns=\"http://www.w3.org/2005/Atom\" xmlns:d=\"http://schemas.microsoft.com/ado/2007/08/dataservices\" xmlns:m=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\">\n <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection</id>\n <title type=\"text\">EmployeeCollection</title>\n <updated>2020-04-09T11:25:13Z</updated>\n <link rel=\"self\" title=\"EmployeeCollection\" href=\"EmployeeCollection\" />\n <entry>\n <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')</id>\n <category term=\"Terrasoft.Configuration.Employee\" scheme=\"http://schemas.microsoft.com/ado/2007/08/dataservices/scheme\" />\n <link rel=\"edit\" title=\"Employee\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy\" type=\"application/atom+xml;type=entry\" title=\"CreatedBy\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/CreatedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy\" type=\"application/atom+xml;type=entry\" title=\"ModifiedBy\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/ModifiedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Contact\" type=\"application/atom+xml;type=entry\" title=\"Contact\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Contact\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnitCollectionByHead\" type=\"application/atom+xml;type=feed\" title=\"OrgStructureUnitCollectionByHead\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/OrgStructureUnitCollectionByHead\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnit\" type=\"application/atom+xml;type=entry\" title=\"OrgStructureUnit\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/OrgStructureUnit\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Job\" type=\"application/atom+xml;type=entry\" title=\"Job\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Job\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner\" type=\"application/atom+xml;type=entry\" title=\"Owner\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Owner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ReasonForDismissal\" type=\"application/atom+xml;type=entry\" title=\"ReasonForDismissal\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/ReasonForDismissal\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Account\" type=\"application/atom+xml;type=entry\" title=\"Account\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Account\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Manager\" type=\"application/atom+xml;type=entry\" title=\"Manager\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/Manager\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByManager\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCollectionByManager\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeCollectionByManager\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCareerCollectionByEmployee\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeCareerCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeFileCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeFileCollectionByEmployee\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeFileCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInFolderCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeInFolderCollectionByEmployee\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeInFolderCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInTagCollectionByEntity\" type=\"application/atom+xml;type=feed\" title=\"EmployeeInTagCollectionByEntity\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/EmployeeInTagCollectionByEntity\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/SalaryCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"SalaryCollectionByEmployee\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/SalaryCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwEmployeesHierarchyCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"VwEmployeesHierarchyCollectionByEmployee\" href=\"EmployeeCollection(guid'9842387d-069f-466c-9551-32cedbc16d90')/VwEmployeesHierarchyCollectionByEmployee\" />\n <title />\n <updated>2020-04-09T11:25:13Z</updated>\n <author>\n <name />\n </author>\n <content type=\"application/xml\">\n <m:properties>\n <d:Id m:type=\"Edm.Guid\">9842387d-069f-466c-9551-32cedbc16d90</d:Id>\n <d:Name>Mary King</d:Name>\n <d:CreatedOn m:type=\"Edm.DateTime\">2017-03-30T14:50:30Z</d:CreatedOn>\n <d:CreatedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>\n <d:ModifiedOn m:type=\"Edm.DateTime\">2017-03-31T07:27:18Z</d:ModifiedOn>\n <d:ModifiedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:ModifiedById>\n <d:ProcessListeners m:type=\"Edm.Int32\">0</d:ProcessListeners>\n <d:ContactId m:type=\"Edm.Guid\">cad50d15-f28d-49fc-aa79-21615ac35b86</d:ContactId>\n <d:OrgStructureUnitId m:type=\"Edm.Guid\">43172897-fbd6-4bc1-b81b-55964ab558e6</d:OrgStructureUnitId>\n <d:Notes></d:Notes>\n <d:JobId m:type=\"Edm.Guid\">955472f0-56e6-df11-971b-001d60e938c6</d:JobId>\n <d:FullJobTitle>Customer manager</d:FullJobTitle>\n <d:OwnerId m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:OwnerId>\n <d:CareerStartDate m:type=\"Edm.DateTime\">2019-04-07T00:00:00</d:CareerStartDate>\n <d:CareerDueDate m:type=\"Edm.DateTime\">0001-01-01T00:00:00</d:CareerDueDate>\n <d:ProbationDueDate m:type=\"Edm.DateTime\">0001-01-01T00:00:00</d:ProbationDueDate>\n <d:ReasonForDismissalId m:type=\"Edm.Guid\">00000000-0000-0000-0000-000000000000</d:ReasonForDismissalId>\n <d:AccountId m:type=\"Edm.Guid\">e308b781-3c5b-4ecb-89ef-5c1ed4da488e</d:AccountId>\n <d:ManagerId m:type=\"Edm.Guid\">e17c9cd6-262d-481d-86a9-f09a82984e0e</d:ManagerId>\n </m:properties>\n </content>\n </entry>\n <entry>\n <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')</id>\n <category term=\"Terrasoft.Configuration.Employee\" scheme=\"http://schemas.microsoft.com/ado/2007/08/dataservices/scheme\" />\n <link rel=\"edit\" title=\"Employee\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy\" type=\"application/atom+xml;type=entry\" title=\"CreatedBy\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/CreatedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy\" type=\"application/atom+xml;type=entry\" title=\"ModifiedBy\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/ModifiedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Contact\" type=\"application/atom+xml;type=entry\" title=\"Contact\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Contact\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnitCollectionByHead\" type=\"application/atom+xml;type=feed\" title=\"OrgStructureUnitCollectionByHead\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/OrgStructureUnitCollectionByHead\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnit\" type=\"application/atom+xml;type=entry\" title=\"OrgStructureUnit\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/OrgStructureUnit\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Job\" type=\"application/atom+xml;type=entry\" title=\"Job\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Job\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner\" type=\"application/atom+xml;type=entry\" title=\"Owner\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Owner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ReasonForDismissal\" type=\"application/atom+xml;type=entry\" title=\"ReasonForDismissal\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/ReasonForDismissal\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Account\" type=\"application/atom+xml;type=entry\" title=\"Account\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Account\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Manager\" type=\"application/atom+xml;type=entry\" title=\"Manager\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/Manager\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByManager\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCollectionByManager\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeCollectionByManager\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCareerCollectionByEmployee\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeCareerCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeFileCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeFileCollectionByEmployee\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeFileCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInFolderCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeInFolderCollectionByEmployee\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeInFolderCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInTagCollectionByEntity\" type=\"application/atom+xml;type=feed\" title=\"EmployeeInTagCollectionByEntity\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/EmployeeInTagCollectionByEntity\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/SalaryCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"SalaryCollectionByEmployee\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/SalaryCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwEmployeesHierarchyCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"VwEmployeesHierarchyCollectionByEmployee\" href=\"EmployeeCollection(guid'3b952b60-2502-4ab2-a967-7f898f8b8b55')/VwEmployeesHierarchyCollectionByEmployee\" />\n <title />\n <updated>2020-04-09T11:25:13Z</updated>\n <author>\n <name />\n </author>\n <content type=\"application/xml\">\n <m:properties>\n <d:Id m:type=\"Edm.Guid\">3b952b60-2502-4ab2-a967-7f898f8b8b55</d:Id>\n <d:Name>Megan Lewis</d:Name>\n <d:CreatedOn m:type=\"Edm.DateTime\">2017-03-30T14:51:27Z</d:CreatedOn>\n <d:CreatedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>\n <d:ModifiedOn m:type=\"Edm.DateTime\">2017-03-31T07:30:20Z</d:ModifiedOn>\n <d:ModifiedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:ModifiedById>\n <d:ProcessListeners m:type=\"Edm.Int32\">0</d:ProcessListeners>\n <d:ContactId m:type=\"Edm.Guid\">27bbc601-2d48-4652-8d18-eb93e718a78c</d:ContactId>\n <d:OrgStructureUnitId m:type=\"Edm.Guid\">43172897-fbd6-4bc1-b81b-55964ab558e6</d:OrgStructureUnitId>\n <d:Notes></d:Notes>\n <d:JobId m:type=\"Edm.Guid\">955472f0-56e6-df11-971b-001d60e938c6</d:JobId>\n <d:FullJobTitle>Customer manager</d:FullJobTitle>\n <d:OwnerId m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:OwnerId>\n <d:CareerStartDate m:type=\"Edm.DateTime\">2019-11-10T00:00:00</d:CareerStartDate>\n <d:CareerDueDate m:type=\"Edm.DateTime\">0001-01-01T00:00:00</d:CareerDueDate>\n <d:ProbationDueDate m:type=\"Edm.DateTime\">2020-02-10T00:00:00</d:ProbationDueDate>\n <d:ReasonForDismissalId m:type=\"Edm.Guid\">00000000-0000-0000-0000-000000000000</d:ReasonForDismissalId>\n <d:AccountId m:type=\"Edm.Guid\">e308b781-3c5b-4ecb-89ef-5c1ed4da488e</d:AccountId>\n <d:ManagerId m:type=\"Edm.Guid\">e17c9cd6-262d-481d-86a9-f09a82984e0e</d:ManagerId>\n </m:properties>\n </content>\n </entry>\n</feed>"
}
]
}
