Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter within API Request

Hello,   i want to set a filter within a JSON Request. The code seems to be ok but i am not seeing the filtered data. for example     Does someone has a tip for me how i can get the filte...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I have found the mistake. Some braces were missing.

     

    filter = [type="C__OBJTYPE__APPLIKATIONSLISTE"], category = "C__CATG__CONTACT",

     --> category = {"C......"}

     

    Neverthless, thank you for your input !

Anonymous's avatar
Anonymous
Not applicable
6 years ago

im sorry, it makes me feel uncomfortable but i dont understand this. is there an example available ? like adding the filter into the json request?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

This does not look like a valid JSON... Is this something you put inside a valid JSON as string parameter?

Can you share the context: the actual JSON being sent (please do not forget to remove any private/confidential data) and the query code that you use to fetch data?

 

Thanks,

JB

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    yes, these are the steps in Power BI:

    It only shows the values of type = "C__OBJTYPE__APPLIKATIONSLISTE" in the results, not the category = "C__CATG__CONTACT" (last picture).

    I cannot see any error.

    1 url2 bodycontent3 body4 source5 result6 converted to table

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      I've tested it by sending this data for MS Flow and checking what comes through. The JSON seem to get to other side as expected.

      Are you sure that in the request it should be 

       

      filter = [type="C__OBJTYPE__APPLIKATIONSLISTE"], category = "C__CATG__CONTACT",

      and not 

      filter = [type="C__OBJTYPE__APPLIKATIONSLISTE", category = "C__CATG__CONTACT"],

       

      isn't category part of your filter?

       

      Kind regards,

      JB

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I have found the mistake. Some braces were missing.

         

        filter = [type="C__OBJTYPE__APPLIKATIONSLISTE"], category = "C__CATG__CONTACT",

         --> category = {"C......"}

         

        Neverthless, thank you for your input !