Skip to main content
Question

Translation Layer for an Inter-app pipeline.

  • Jun 2, 2026 4:17 PM UTC
  • 3 replies
  • 146 views

Forum|alt.badge.img+1

Hey Qrew!

Question for your expertise.

I have a request from my userbase to create a number of pipelines to help transmit a request from one app to another.

The gist is, when a request in system A meets certain criteria, that request needs to be submitted in system B or C. The pipeline will take the request details from system A and distribute them to the appropriate system.

The roadblock I'm facing is that I have site (name, company, address, etc) and site contact (name, email, phone, etc) data that needs to be brought over from system A into B or C, but none of the record IDs match between these systems. So if I use the pipeline and pull site record ID 10 from system A, site record ID 10 will pull something completely different in B and C. 

I need either a translation layer in each system, or if there is a way to universalize without ruining existent data, I would prefer that.

As always, your wisdom is appreciated!

3 replies

MarkShnierYou
Forum|alt.badge.img+24

Well, this could get ugly in a hurry because it sounds like you don't have a consolidated company wide table for sites and Contacts.

So obviously in hindsight, the right solution is to have a table which is the single source of truth that all users update for this information and then all apps will draw from that Data either in across App relationship, but a better practice would be to have Connected Sync tables in each of the apps so the users get to see what's in the site table in the Contacts table locally within their own app. It also prevents Cross application dependencies which will approve the performance of the apps if you have a lot of data or a lot of transaction volume. 

Assuming factors like people names and site names are spelled perfectly exactly the same in both systems you can have a pipeline that goes off and searches for the site name in the other application and then uses that Record ID.   But in free form data entry in the separate systems for the site name,  it's very easy to get slightly different site names for the same physical site.

An interim solution would be to populate some pure data entry fields with those details and have a human intervene where the pipeline wasn't able to find an exact match.  


Forum|alt.badge.img+11
  • Qrew Captain
  • Jun 2, 2026 5:27 PM UTC

What is the relationship between A, B, and C? Do they have anything in common?

Are you wanting to create new requests in B or C based on request submitted in A, or are you updating existing records in B and C based on A? Do you need these records synced or related in some way?

If you need some kind of match or sync, then you must create or identify some commonality and use that to associate or create your own new ID to associate the records.


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 21, 2026 6:20 PM UTC

Building on what Mark and Denin said, the simplest translation layer is to store System A's Record ID in B and C.

Add a field to the Sites table in B and C, something like [System A Site ID], and set it to unique. Do the same for Contacts. Your pipeline then never needs B's Record ID up front. It searches B for that A ID, and if it's not there it creates the site.

For the data you already have, you only backfill that field once. Export sites from A with their Record IDs, match them to B and C by name and address (the one manual part), and import the A IDs into the new field.

After that, a Bulk Upsert merging on [System A Site ID] keeps B and C in step, and new requests can point at the right site.

Long term, Mark's point still stands. One shared Sites and Contacts table that the other apps sync from makes this problem go away.