gistfile1.txt

import synapseclient
import synapsebridgehelpers as sb

FILTER_QUERY = "SELECT distinct healthCode FROM syn7841519 where substudyMemberships like '%Cirrhosis_pilot%'"
ORIG_PROJECT = 'syn7838471'
DESTINATION_PROJECT = 'syn18589808'
TABLE_MAPPING = {'syn7841519': 'syn18632063'}


syn = synapseclient.login()

healthCodes = syn.tableQuery(FILTER_QUERY).asDataFrame()


out = sb.export_tables(syn, table_mapping= TABLE_MAPPING, identifier_col = 'healthCode',
                      identifier=list(healthCodes.healthCode))