Using GET in webhook to find usage data in Stripe and add it to Sheets - with a changing URL

Thanks! Heres the link:-)

https://stripe.com/docs/api/usage_records/subscription_item_summary_list

This is the URL:

https://api.stripe.com/v1/subscription_items/si_HxZw9nI5cF9mQu/usage_record_summaries

“si_HxZw9nI5cF9mQu” is an example of a Subscription Item ID (SI ID).

This is what I get back:

“{
  "object": "list",
  "url": "/v1/subscription_items/si_HxZw9nI5cF9mQu/usage_record_summaries",
  "has_more": false,
  "data": [
    {
      "id": "sis_1DKJ5IBXVOy2SlndSwCc4aBk",
      "object": "usage_record_summary",
      "invoice": "in_1DKIYGBXVOy2SlndfBkBDtwi",
      "livemode": false,
      "period": {
        "end": 1539321672,
        "start": null
      },
      "subscription_item": "si_Dlqmz3K16t9Vdb",
      "total_usage": 123
    },
    {...},
    {...}
  ]
}”

The data I need is the “total_usage” and I need that for every single subscription we have on a weekly basis.

I have the SI ID’s in Stripe and Sheets.

I have no idea how to make Zapier find the SI ID and merge it with the URL and make a call per SI ID we have and return the usage data to Sheets.

@Danny Fabricius Fogel 

If you are trying to create a looping Zap that goes thru all the rows of a GSheet, then check out this related topic:

Sounds great but what do I write in the required Lookup value, when it should just go through one row at a time?

Got it! So now everything seems fine, except I’m not sure how to make it circle back to the trigger. Which data do I use from the final step POST webhook in the CATCH webhook trigger to get it started again? Which fields do i need to update in the POST and CATCH webhooks?

Amazing! And to restart it I then create a Zap that changes the “Done” column in Sheets back to “no” and then activate the trigger e.g. once a week with a scheduled Zap?

Thanks:-)