I’ve been using Power Automate to send/track agreements sent by our legal team for about a year. Sending an envelope inserts a record into our MSSQL database, and the tracker PA updates the row when an envelope status changes.

The contracts team recently reached out and wants to start recording the reasons that envelopes are being voided/declines. Previously I was just tracking if they were or not, but added a new column to the SQL table for ‘reason’. Capturing the reason for future envelopes has already been implemented, but I have ~350 voided envelopes I would like to retroactively access the ‘void reason’ for. 

I have all the envelope IDs that I need, but is there an API endpoint that I can call to get the void/declined reason? If I have to make two PAs (one for void, the other for decline, as the JSON packages are slightly different), that’s fine. I just haven’t found anything that works so far.

Thank you!