Get Items for Zendesk connector fails without Maximum Get Count in Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-739223%22%20slang%3D%22en-US%22%3EGet%20Items%20for%20Zendesk%20connector%20fails%20without%20Maximum%20Get%20Count%20in%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739223%22%20slang%3D%22en-US%22%3E%3CP%3EScenario%3A%20I%20want%20to%20record%20our%20daily%20open%20tickets%20(actually%20the%20count%20of%20items)%20in%20Zendesk%20to%20Excel%20Online%20in%20OneDrive.%20Our%20ZD%20plan%20does%20not%20provide%20this%20in%20the%20ZD%20UI.%20I%20created%20a%20new%20scheduled%20Flow%20based%20on%20the%20existing%20Get%20Items%20action%20for%20Zendesk.%20I%20am%20able%20to%20get%20the%20filtered%20items%20and%20compose%20the%20number%20of%20open%20tickets%20and%20store%20it%20in%20a%20Excel%2C%20so%20the%20whole%20process%20works.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EProblem%20is%20that%20the%20Get%20Items%20works%20only%20if%20I%20specify%20the%26nbsp%3BMaximum%20Get%20Count%20to%20be%20lower%20then%20the%20actual%20number%20of%20open%20tickets.%20If%20I%20leave%20it%20blank%20(the%20description%20of%20the%20field%20says%20the%20default%20there%20is%20512%20records)%2C%20the%20Flow%20gets%20stuck%20in%20trying%20to%20get%20the%20records.%20Example%3A%20We%20have%2025%20open%20tickets%20and%20I%20set%26nbsp%3BMaximum%20Get%20Count%20to%20be%2025%20or%20under%2C%20everything%20works.%20If%20I%20set%20it%20to%2026%20or%20higher%2C%20the%20Get%20item%20phase%20never%20finishes%20and%20the%20flow%20fails%20after%204%20retries.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EZendesk%20Get%20Items%20is%20still%20in%20Preview%20mode.%20Is%20this%20still%20just%20a%20bug%20or%20am%20I%20doing%20something%20wrong%3F%20This%20is%20my%20first%20Flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-739223%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741696%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Items%20for%20Zendesk%20connector%20fails%20without%20Maximum%20Get%20Count%20in%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741696%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F371563%22%20target%3D%22_blank%22%3E%40Pekka_Aho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20possible%20that%20your%20flow%20is%20waiting%20for%20the%20criteria%20to%20be%20met%20before%20proceeding%20with%20the%20output.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20a%20user%20of%20ZenDesk%20so%20you'll%20have%20to%20play%20with%20this%20idea%2C%20but%20you%20could%20use%20Get%20items%20to%20retrieve%20all%20open%20tickets%20first%20into%20an%20Excel%20spreadsheet%20template%2C%20do%20a%20count%20of%20how%20many%20records%20there%20are%2C%20and%20then%20use%20that%20count%20to%20inform%20the%20Maximum%20Get%20Count.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20to%20be%20vague%20but%20without%20seeing%20ZenDesk%20in%20action%2C%20it's%20a%20working%20theory%20that%20hopefully%20gives%20you%20some%20ideas%20to%20solve%20your%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

Scenario: I want to record our daily open tickets (actually the count of items) in Zendesk to Excel Online in OneDrive. Our ZD plan does not provide this in the ZD UI. I created a new scheduled Flow based on the existing Get Items action for Zendesk. I am able to get the filtered items and compose the number of open tickets and store it in a Excel, so the whole process works.

Problem is that the Get Items works only if I specify the Maximum Get Count to be lower then the actual number of open tickets. If I leave it blank (the description of the field says the default there is 512 records), the Flow gets stuck in trying to get the records. Example: We have 25 open tickets and I set Maximum Get Count to be 25 or under, everything works. If I set it to 26 or higher, the Get item phase never finishes and the flow fails after 4 retries. 

 

Zendesk Get Items is still in Preview mode. Is this still just a bug or am I doing something wrong? This is my first Flow.

1 Reply

Hi @Pekka_Aho 

 

It's possible that your flow is waiting for the criteria to be met before proceeding with the output.

 

I'm not a user of ZenDesk so you'll have to play with this idea, but you could use Get items to retrieve all open tickets first into an Excel spreadsheet template, do a count of how many records there are, and then use that count to inform the Maximum Get Count.

 

Sorry to be vague but without seeing ZenDesk in action, it's a working theory that hopefully gives you some ideas to solve your issue.

 

Cheers and best wishes

Damien