The API importer requires an ID to match up related collections.
The client is supplying the import csv file, so I can't expect them to know the IDs to the related items. I want to use the title instead (for instance).
I want to check each item's title against the collection, match the ID and then pass it into the importer.
How would I go about making a query similar the following in an app using the API? I am completely new to this so please be gentle with me. Any help greatly appreciated.