Web API connection - Logical operator help

[Anonymous]

Hi all, 

I have a Web API connection set (CRM tool) set and i want to extend the data based on the value of 'Type' field.

The Type field contains 10 possible values. I want only 3 of them.

The source is configured as below :

...api/xml/Tickets?DateCreated=20190311000001&Type[contains]=Enhancement&pageSize=2000"

How can extend the data to be Type[contains]=Enhancement OR Type[contains]=Access OR Type[contains]=Defect

Thanks for your help

[mahoneypat]

Does it hurt performance/refresh too much to just bring it all in (remove the existing filter on Type) and filter in query?  If so, you'll have to look at the syntax for your API, but does it accept them provided in a comma separated list?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Thanks for your answer. Yes it will impact the performance this is why i need to get only those values. 

Sorry i'm very new with this, where can I found the API syntax?

[v-chuncz-msft]

@Anonymous 

You may refer to the post below that invokes Custom Function in Query Editor.

http://community.powerbi.com/t5/Desktop/Create-tables-based-on-all-Query-Parameters/td-p/345947

[Anonymous · Accepted solution]

Thanks for your help. The issue is fixed by adding '&' for each type.