API search options
Peter Ronhovde
After checking the SmartSuite API documentation several times, as far as I can tell we can only search for a record using the record ID.
This is very limiting when connecting to other applications since potential new data from the external source will not have any SmartSuite record ID (that we know of at that time). We have no way of validating the existence of a user already in the database.
Please implement an API search option using another field other than the SmartSuite specific record ID such as name or email address (or any field would be best).
Brandi Bullock
Can you add a filter based on the item you are looking for?
Peter Ronhovde
Brandi Bullock: You could add a filter, but at least on Make.com you can only retrieve a maximum of 100 records at a time. So, you would have to page through them while searching every time you are simply checking whether the record exists. This would be a problem if you have thousands of records. Plus every page may be a separate API call, and we only have a fixed number per month,
Brandi Bullock
Peter Ronhovde: I was suggesting possibly adding a filter to the email or phone number to check to see if that exists in the record set. Not sure if that would work for your use case.