Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
9 months ago
Solved

Assistance with Power Query – Missing ‘Closed’ Status in Data Extract

Hi, I need some assistance with Power Query. I’m using a script to retrieve all status data, but I’m not getting the expected results—for example, statuses marked as ‘Closed’ are missing. I can’t fi...
Need Help
  • ashmitp869's avatar
    ashmitp869
    9 months ago

    Hi PhilipTreacy 

    I found the correct one, I was missing {} 

     

    filter = {"moduleName:Incident Reporting", "archivedStep:true", "form:2"}

     

    Thanks for all your guidance

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
9 months ago

Hi ashmitp869 

 

The 3rd party API call you've shown is using a URL parameter filter=fieldsToValues.status:Closed but your M code is not.  Do you need to include this in your query?

 

Have you tried calling GetPage in a separate query and confirming what data it returns?

 

Is it possible that in your query above, when you do the #"Expanded Column2" step that you aren't actually expanding the record with the Closed status data?

 

Regards

 

Phil