+ Reply to Thread
Results 1 to 3 of 3

I really need a Google Sheet function pull access_token in API

  1. #1
    Registered User
    Join Date
    12-16-2021
    Location
    Vietnam
    MS-Off Ver
    2013
    Posts
    1

    Lightbulb I really need a Google Sheet function pull access_token in API

    Hello guys,

    I have a job that has to do with Google Sheets and would love to get your support in the MrExcel community

    I would like to ask you to help me create a Google Sheet function located in the column Access_Token_from_API_URL to get the value of Access_Token in the link located in the column API_URL.
    It is the cluster of characters that are bolded below
    {"r":0,"msg":"Success","data":{"access_token":"eyJjdHkiOiJzdHJpbmdlZS1hcGk7dj0xIiwidHlwIjoiSldUIiwiYWxnIjoiSFMyNTYifQ.eyJqdGkiOiJTS0dvSkxlWkZuRHhYZjRtd0U3cUllYjJTa3dFRE5ZYy0xNjM5NjU5MzA3IiwiaXNzIjoiU0tHb0pMZVpGbkR4WGY0bXdFN3FJZWIyU2t3RUROWWMiLCJleHAiOjE2Mzk3NDU3MDcsInVzZXJJZCI6IjA5MTk5OTk5OTk5IiwiY2FuQ2FsbG91dCI6ZmFsc2V9.d6CnwcmHDI1MOOaBsrTHm6P1-YZUizY_PLh0kyNRSL4"}}

    Thank you for reading and helping me. Wishing you all a merry and peaceful Christmas!
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,152

    Re: I really need a Google Sheet function pull access_token in API

    If you give the API URL here, a script can be written to get the necessary data.

    .

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,421

    Re: I really need a Google Sheet function pull access_token in API

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. combination function in google sheet
    By guyati1234 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 08-27-2021, 11:37 PM
  2. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  3. Question about if this excel/google sheet function is possible
    By nikeman88 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-19-2019, 06:53 PM
  4. Question about if this excel/google sheet function is possible
    By nikeman88 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-19-2019, 06:53 PM
  5. Upload excel sheet to google translate (and pull the result) via VBA
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2017, 04:02 PM
  6. Pull google results - title, description,url into excel sheet using VBA
    By joewhyte in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 09:53 PM
  7. google spreadsheet need function/code to pull data from one sheet to another
    By venusrena in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 04-27-2013, 04:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1