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