Is there anyways to get id from upsert or insert query?

[kazutoshi.sugita]

I have workflow which upsert's transactional data and after that create data which related to that transaction.
therefore i need id which is updated or inserted during the workflow.

it seems information in return so im currently call select query by getting max(id) but assuming there is more than 2 people using same workflow will cause problem so i would like to know if there is anything better way to do.

thanks in advance,

[whynot]

The only way i'm aware of is running a subsequent query with the keys that inserted the previous row and get the id back.

[Tess]

Hi @kazutoshi.sugita can you also share what resource type is doing the upsert (MySQL, Postgres, etc)?