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

ashmitp869 

 

Also, try this - note that syntax around the filter parameters

 

    baseUrl = "https://api.myosh.com/v3/inf/records",
    GetPage = (offset as number) =>
        let
            response = Json.Document(
                Web.Contents(
                    baseUrl,
                    [
                        RelativePath = "",
                        Query = [
                            rowLimit = "1000",
                            sort = "creationDate",
                            asc = "false",
                            mobileOnly = "false",
                            #"filter" = "moduleName:Incident Reporting",
                            #"filter" = "form:2",
                            #"filter" = "archivedStep:true",
                            #"filter" = "deleted:false",
                            offset = Number.ToText(offset)
                        ],
                        Headers = [
                            #"x-api-key" = apiKey,
                            #"Authorization" = authHeader,
                            #"Accept" = "application/json"
                        ]
                    ]
                )
            ),
            results = try response[results] otherwise {}
        in
            results

 

Phil

 

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

Hi ashmitp869 ,

Could you please try the proposed solutions shared by  PhilipTreacy ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

 

Regards,

Dinesh