Web.contents regex

[Digger]

How do get value from Web.contents response

for example

<input type="hidden" name="authenticity_token" value="sUX0u4idK1B1PuhPKIvRI/vlO3iuTeGvK7MLoJZ9X+Ag==">

i need get authenticity_token value

but got empty values

How to do that?

[Digger · Accepted solution]

solved
= Html.Table(Search, {{"Input", "[name=""authenticity_token""]", each [Attributes][value]}})

[amitchandak]

@Digger , Are you looking for Token based Auth ?

https://community.powerbi.com/t5/Desktop/Pull-data-from-RESTful-API-with-token-authentication/m-p/80...

[Digger]

@amitchandak  yes, but your example does not extract anything from page, you must provide auth token, but dont have it, as first call i must get auth token from login page and then send credentials both with token

[amitchandak]

@Digger , You have auth token ?

if yes

Check this example

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

[Digger]

@amitchandak  ofcource nobody has auth token, as it is inside input tag, and you example will not work for anybody