Accessing Import ID for related records in Query API

Aaron Spike

Sorry for doubling posting. I posted about this in Financial Edge General Discussions, but I think it is more fitting here.

I'm using the Query API to retrieve information from the Receivables module about Clients Automatic Payment configuration. I would like to use this information to Import changes to the Default Amount field. I've tested the import procedure in the Total Web Solution and it is working. To accomplish the import I need access to the Import ID of the Automatic Payment record related to the Client via Query API. Why Query rather than Import or Export? Because I want the process to require as little user interaction and as few steps as possible. I can obtain the Client Import ID via query, but I cannot locate the Import ID for Automatic Payment (or any other related records) in Query.

A support representative has confirmed that Import IDs for related records are not currently available in Query and that there are no appropriate API endpoints for working with this information.

I have added a feature request in the ideas portal:
https://financialedge.ideas.aha.io/ideas/FENXT-I-3933

Does anyone know where this is on the roadmap? Can you recommend other options for creating an integration like this?

Crystal Bruce

Hi @Aaron Spike I am checking with my team on the roadmap question and will post the answer on the other discussion here:

Accessing Import ID for related records in Query

Thanks!