I have to migrate data from several tables in instance A to instance B (Prod to Prod). Each table has multiple reference fields and none of the data exists in target instance. For compliance i cannot use export/import method. Possible option i have is create a REST integration hub data source. I'm stuck with using table api when it comes to having multiple reference fields. For example, 'Customer Order' table has a reference field to 'Account'. I have to filter for Orders on a 'X' field and migrate accounts that are referenced in those filtered orders. How can i migrate those accounts using table API?
