Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Get List of Work Items: Freshdesk to Azure



I am trying to create a flow from Freshdesk to Azure. When a new ticket is assigned a 'Bug' type or an existing ticket is assigned a 'Bug' type in Freshdesk, a new work item needs to be created. 


The flow for Creating a New ticket in Freshdesk I got right, but the one for an existing ticket that gets updated to a Bug type is a little trickier. I tried using the same logic as the New ticket flow, but that ends up creating multiple work items in Azure for the same Freshdesk ticket. So I tried this post:



It uses "List Work Items" to get a list work item IDs and matches Titles of the work item to the Freshdesk subject to avoid duplication, but here I ran into the problem of not knowing how to get all work item IDs??





So in order to get a list of all the IDs, I tried "Get Query results" with a query in Azure that lists all the work item IDs when the type of the work item is a Bug. This query literally lists only the IDs in Azure.  




But when I try the Flow, it fails on getting the query results with this error:


  "error": {
    "message""The response is not in a JSON format.",
    "innerError""The resource you are looking for has been removed, had its name changed, or is temporarily unavailable."
Any idea what I'm doing wrong or have another way I can get all work item IDs in this "List work items" step?

Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (95,442)