About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Extract part of a python response

  • 22 November 2021
  • 2 replies
  • 220 views
T
Userlevel 1

Hello,

I have a step in my Zap where I need to retrieve a bearer token to use for a later step. This token can be retrieved within a response from a python request.

My response in Zapier looks like this:

 

output_missing

Please define output or return early.

id

8KzjgJ7iu86HBhkCxXu5L8hSoc5sD3Qq

runtime_meta

memory_used_mb

47

duration_ms

857

logs

1

{"expiresAt":"2021-12-22T02:13:20Z","cultureId":1,"companyAccountId":20,"userAccountId":47,"newUrl":null,"refreshToken":"z8+7NQrtekQ35vrR6l03cn+V4mL6CBazO0WACqYjzM0=","token":"{TOKEN}","role":"CorporateInterpreterRootAdmin"}

 

 

I need to extract the {TOKEN} value and be able to re-use it as a field in a later action step.

I tried a few output/return options, but I’m not sure how to do this.

 

Any ideas?

 

Thank you

Thomas

icon

Best answer by robschmidt 22 November 2021, 03:30

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

robschmidt
Userlevel 7
Badge +9

Hi @Thomas2M 

You can use python for this (read Zapier python help docs on how to format your code) or you can use formatter>text>extract pattern and use a regex query to extract the token part. This should be more convenient to work with.

 

Outliant.com | Zapier Expert
T
Userlevel 1

Hi @robschmidt,

Thank you for pointing me out in the right direction. The formatter with python regex did the trick.

In case this is helpful for the forum users, here’s the regex I used: (?<="token":").+(?=",)

 

Terms & Conditions