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

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
9 months ago

Hi ashmitp869 ,

Thank you for reaching out to the Microsoft Community Forum.

 

You are not getting any “Closed” records because your Power Query request is not applying the same filter that the third-party API call is using. The third-party request shows below filter.

 

filter=fieldsToValues.status:Closed

 

But your Power Query script never includes this filter.

 

Please update your query parameters section with below code.

 

queryParams = [
sort = "creationDate",
asc = "false",
mobileOnly = "false",
filter = "moduleName:Incident Reporting",
filter1 = "form:2",
filter2 = "archivedStep:true",
filter3 = "deleted:false",
filter4 = "fieldsToValues.status:Closed",
rowStart = Text.From(offset),
rowLimit = Text.From(pageSize)
],

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

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

Thx v-dineshya , I already pointed this out in my 1st reply.

 

Regards

 

Phil

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    9 months ago

    Hi PhilipTreacy ,

    Sorry , i din't observe your previous response. 

     

    Regards,

    Dinesh