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.