Issue with RelativeEndpoint for OrchestratorHttpRequest Activity

Hi, everyone.

Can anyone see what’s wrong with my relative endpoint here?

This was working fine when I had it written as:

String.Format(“/odata/QueueItems?%24filter=CreationTime%20lt%20{0}%20and%20QueueDefinitionId%20eq%20{1}&%24select=Status%2CReference%2CStartProcessing%2CEndProcessing%2CSpecificContent%2COutput%2CCreationTime%2CDeferDate%2CDueDate%2CProcessingException&%24orderby=StartProcessing%20asc&%24top=1000&%24skip={2}&%24count=true”,in_LastReportRunDateTime.ToString(“yyyy-MM-ddTHH:mm:ss.FFFZ”),queueIdFolderProcess.Split(","c).First,skipItemsCount.ToString)

Then I tried to add the following to the Endpoint to also filter by a status of “Completed,” and I’m getting a 400 code that this is an invalid request. Any ideas how to filter by the Status, too?

String.Format(“/odata/QueueItems?%24filter=CreationTime%20lt%20{0}%20and%20QueueDefinitionId%20eq%20{1}%20and%20Status%20eq%20Completed&%24select=Status%2CReference%2CStartProcessing%2CEndProcessing%2CSpecificContent%2COutput%2CCreationTime%2CDeferDate%2CDueDate%2CProcessingException&%24orderby=StartProcessing%20asc&%24top=1000&%24skip={2}&%24count=true”,in_LastReportRunDateTime.ToString(“yyyy-MM-ddTHH:mm:ss.FFFZ”),queueIdFolderProcess.Split(","c).First,skipItemsCount.ToString)

Hi @Joe_Matuch ,

You need to single quote the status parameter

/odata/QueueItems?%24filter=QueueDefinitionId%20eq%{1}%20and%20Status%20eq%20'Completed'
1 Like

Thanks, @Edwin_Barahona . I actually just found this post, which showed me that I need to do what you are saying, but I need to use %27 (the hex for ') instead of putting the ’ directly in the string.

String.Format(“/odata/QueueItems?%24filter=CreationTime%20lt%20{0}%20and%20QueueDefinitionId%20eq%20{1}%20and%20Status%20eq%20%27Completed%27&%24select=Status%2CReference%2CStartProcessing%2CEndProcessing%2CSpecificContent%2COutput%2CCreationTime%2CDeferDate%2CDueDate%2CProcessingException&%24orderby=StartProcessing%20asc&%24top=1000&%24skip={2}&%24count=true”,in_LastReportRunDateTime.ToString(“yyyy-MM-ddTHH:mm:ss.FFFZ”),queueIdFolderProcess.Split(","c).First,skipItemsCount.ToString)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.