I’m using a dynamic query to retrieve data from API data source. The query is intended to pull a list of client names and populate a drop down with those client names only where ‘client names’ match the jira ‘Organization’ of the requesting customer portal user.
I suspect the currentUserOrganizations is not found since the drop down shows all client names, not just the ones the user is a member of.
<#if currentUserOrganizations?? && currentUserOrganizations?size gt 0>
<#list currentUserOrganizations as org>
<#if org_index gt 0>,</#if>
Refer to the query below:
DataSoucre Hubspot_API
Path: /objects/companies/search
Request Body
{
“limit”: 100,
“sorts”: [
{
“propertyName”: “name”,
“direction”: “ASCENDING”
}
],
“properties”: [“name”, “recruiter”, “departments”, “active_client”],
“filterGroups”: [
{
“filters”: [
{
“propertyName”: “active_client”,
“values”: [“0”, “1”, “5”],
“operator”: “IN”
}
<#if currentUserOrganizations?? && currentUserOrganizations?size gt 0>
<#list currentUserOrganizations as org>
<#if org_index gt 0>,</#if>
{
“propertyName”: “name”,
“value”: “${org}”,
“operator”: “IN”
}
</#list>
</#if>
]
}
]
Locations of Connected item options in response: results
Template: ${row.properties.name}