API Get with multiple parts

[Pingzinggolf]

I am new to API and I am in Swagger and looking at - GET- /v2/tables/{tableName}/records

I can select based on one COL - Example...

https://********.caspio.com/rest/v2/tables/Incoming_Leads/records?q.where=Lead_Source%3D'Medical%20Physicist%20Opportunity%20in%20Missouri%20Available'

How do I select with 2 fields like

Select * from table where Lead_Source='asdfasdf" and Email = 'asdfasdfasdf'

https://********.caspio.com/rest/v2/tables/Incoming_Leads/records?q.where=Lead_Source%3D'Medical%20Physicist%20Opportunity%20in%20Missouri%20Available'?????????????

I tried to add 2 fields to the WHERE clause but I am not sure how.

 

Thanks

https://c2afw033.caspio.com/rest/v2/tables/Incoming_Leads/records?q.where=Lead_Source%3D'Medical%20Physicist%20Opportunity%20in%20Missouri%20Available'

[CoopperBackpack]

Hello @Pingzinggolf,

In case you want to get all fields that meet the criteria Lead_Source='a" and Email = 'b' (just example), please use AND logic operator.

Please see a screenshot:

If the Lead_Source and Email fields have Text(255) data type, use single quotes to wrap the values as shown on the screenshot.

Hope this helps.