Filter within API Request

[Belvedere90]

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 filtered data shown? This filter works with another API Tool.

Thanks in advance

[v-frfei-msft]

Hi @Belvedere90 ,

Hope this third - party article can help you.

https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters

[Belvedere90]

Thank you v-frfei-msft

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]

Hi @Belvedere90 ,

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

[Belvedere90]

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]

Hi @Belvedere90 ,

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

[Belvedere90 · Accepted solution]

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 !