Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Web API connection - Logical operator help

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

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

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

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    6 years ago

    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