Hi, I am using Clearbit’s API to autocomplete a search and return the website name, domain, and logo. My problem is that they do not have 100% of the websites I need so I was thinking I could make a data type for the websites they don’t have info on and manually add the info. But I don’t see any way to have a repeating group pull from an external API and a data type.
I also thought about saving the data from Clearbit to the data type and just pulling everything from there but I would still need the user to search using their API in order to populate the data in the first place which leads to the same problem.
For the simple version, this is what I’m doing, just an input and repeating group with data from an API.
but I want to add results from a data set or some other possible work around.
This operation merges two lists of things. It returns a new list with entries from both lists. If an entry is in both, it will only appear once in the returned list.
How would I go about doing that? Using the repeating group only lets me pull from one type of content as far as I know, and the API data and data type data would be coming from different content types.
You’d actually need to use a few repeating groups to make it work as one merged list OR you can just stack one repeating group on top of the other - i.e. the top repeating group could be clearbit and the bottom could be your own database. Obviously they operate totally independent so you might end up with duplicates if Clearbit decides to add those websites.
If you wanted to merge them (therefore remove duplicates) you do it like this. For name/domain set it to text and for image set it to image.
On the left is my text repeating group and right is image. I could add another text repeating group for domain if I wanted. Of course you can adjust the width and styling so it looks more natural.
In this case I have a record with a name ‘supportdeptt’ in my db, so it’s returning this.
The only challenge with doing a basic search like this for the data is that it’s case sensitive and an exact match. So you might want to put everything in lowercase in the db and then add a :lowercase to your search when you reference the input field.
Josh @ Support Dept
Helping no-code founders get unstuck fast save hours, & ship faster with an expert on-demand