+ Reply to Thread
Results 1 to 3 of 3

How To import data from API Json

Hybrid View

ahmirof How To import data from API... 09-14-2022, 03:24 AM
Glenn Kennedy Re: How To import data from... 09-14-2022, 03:31 AM
ahmirof Re: How To import data from... 09-18-2022, 07:30 AM
  1. #1
    Registered User
    Join Date
    06-29-2022
    Location
    LA
    MS-Off Ver
    2019
    Posts
    3

    How To import data from API Json

    Hi,
    I have a website which people can import data by my API section to their own website. But now I am trying to import the data to excel sheet.
    This is my website API document URL : neofollower (dotcom)/panel/api/docs

    I want to import the "Services List"

    it has two parameters :
    key Your API key
    action services

    and the api url: neofollower (dotcom)/panel/api/v1

    the api key is unique for every user

    My excel is Professional Plus 2021

    I tried with Data- New query- From other resources- From web - then :

    Url parts: neofollower(dotcom) /panel/api/v1
    http request header :
    key my API key
    action services

    but i dont get any results
    what should i do?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How To import data from API Json

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    06-29-2022
    Location
    LA
    MS-Off Ver
    2019
    Posts
    3

    Re: How To import data from API Json

    I didn't post any picture and Excel sheet? did you read my post?

    This i my second time i am asking something on this forum, i just got a warning without any other answer about my own problem.

+ 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. import web json data to excel page
    By emn123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2021, 01:47 PM
  2. Automate Powerquery JSON File Import with VBA
    By Chris.Leo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2020, 11:26 AM
  3. Edit JSON parser code to add function to write JSON file
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-16-2020, 09:28 PM
  4. Import Json data in Excel in a tabular format
    By sabha in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-17-2019, 03:15 PM
  5. Import JSON to Excel 2007
    By mcchurchmouse in forum Excel General
    Replies: 1
    Last Post: 12-20-2017, 11:28 AM
  6. Import JSON Api to Excel
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2014, 01:42 PM
  7. Import JSON in Excel by macro
    By bmmerkx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 09:39 AM

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