How can I see who approved or changed status of a file?

[leafy.link]

I am trying to see who approved of a video, and i can not, and it is bugging me.
I want to create an automation that lists who did it
am i am having a hard time

[CharlieAnderson]

hi @leafy.link I was able to get this working with some custom code (and I’ve asked the team if we can make this simpler for the future) in Zapier. Here’s what I did:

1. Set up the Metadata Value Updated to filter on New Field Value
   

   
   
   
   

2. Set up Show File to get the view url
   

   

3. Use the Custom API (SDK) action to get the List Account Permissions endpoint
   

   

4. Set up some Custom Code (Javascript) to extract the username from the raw output of the previous SDK step
   

   

const userId = inputData.userID;
const raw = inputData.stepOutput;

const idx = raw.indexOf(userId);
if (idx === -1) {
  return { userName: "Unknown User" };
}

const after = raw.substring(idx, idx + 500);
const nameMatch = after.match(/name[\\"]*\s*:\s*[\\"]*([\w\s]+)/);

return {
  userName: nameMatch ? nameMatch[1].trim() : "Unknown User"
};

5. Use that to have slack send me a message everytime a status is changed.
   
   
   
   
   

full zap looks like this