I am attempting to create a scenario that will take certain Freshdesk tickets and put them in a bigquery table.
If the ticket id already exist in the table I want that row to be updated.
I have the create new working well, but I am not sure exactly how to check if the ticketID already exist and how to update a row instead of creating a new row.
Any help is greatly appreciated.