Need Help with Workflow Involving ShotStack and Airtable

How To
, ,
1

I’ve been wrestling with integrating ShotStack and Airtable for two full days, and I’m stuck. Hoping someone here can help me figure this out.

Here’s what I’m trying to do:

Scenario 1:

  • Task: Compress an MP4 file using ShotStack.
  • Details:
    1. MP4 file is sent to ShotStack for compression.
    2. On completion, ShotStack triggers a webhook (leads to Scenario 2).
    3. Meanwhile, an Airtable record is updated with the MP4 file’s unique ID and sets “Status = Processing”.

Scenario 2:

  • Task: Receive output from ShotStack and update Airtable.
  • Details:
    1. A webhook receives completion data from ShotStack.
    2. Airtable needs to locate the record using the MP4 file’s unique ID and update the “Status” to “Done”.

Challenges:

  • ShotStack’s payload doesn’t support adding metadata or extra parameters to pass the file’s unique ID directly.
  • The webhook URL cannot include additional query parameters to carry the file ID, as the data returned in the webhook doesn’t include this ID.
  • Organization and scenario variables aren’t viable either, as they could be overwritten by another instance of Scenario 1 by the time Scenario 2 processes, which prevents consistent data tracking.

Question: How can I pass the file ID from Scenario 1 to Scenario 2 effectively, given these limitations?

Any suggestions or workarounds would be greatly appreciated!

2

Hello @SycOps,

If it’s allowed then try to use file names with different separators(name_recid). When you get the filename back just parse it again and get that from the name.

Otherwise last option is need to use status or time-based. Like which record has the last updated status within the specific time frame.

I hope this helps.

3

I am grateful for your input. This is great. Gives me options to look into.

Cheers

4

Hello @SycOps,
If this helps you with your implementation then :white_check_mark: Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.

:+1:

1 Like