Matching child records retrieved from API

I have an API Call that calls Google books and returns a list of books, based on a parameter from a data field on a parent record. I want to populate a books object which has a many to one relationship with the parent object. So I have used an API template for the returned book data and set the base object of the API Call to the parent object. All good so far.

What I would like to do is match book records returned from the API with any existing book records for the same parent and not create them. I have made the API call ‘One record’ and selected Auto Match as the Action option. Within the template I have set the ‘Title’ field for my Book object to ‘Match’.

I would expect this setup to match books by title, and just update if matched. It never appears to match, always creating a duplicate book record under the one parent.

I feel like I am missing something simple here.

1 Like

I think I have answered my own question here …

In the book template I needed to indicate a unique/matching field by using the ‘Link’ option - I had been using the ‘Match’ option.

1 Like

Just to confirm, yes using Link is what you need here.
The “Match” options only apply to matching the base record, in your case the parent record.
“Link” is then used to relate that base record to other records which may or may not already exists. Ticking “Link” on one or more related fields will try to find an existing record with those details and link (aka relate) to it, otherwise create a new one (assumign you have “Save” ticked too).

1 Like

Hi Bob, appreciate the confirmation. Always good to know I have found the actual solution rather than a ‘work around’!