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.   T...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

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

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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?