Closed Thread
Results 1 to 2 of 2

Web Query not working for one ID, but is for another

  1. #1
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,831

    Web Query not working for one ID, but is for another

    I have a query that goes to a webpage, but sometimes I get an error, other times it's successful. I've cut it down to just the bare minimum for this forum. Unfortunately you won't be able to execute it fully, but maybe you can see something. The URL string takes an "Organization" ID. For 8 of my organizations, this works. For 4 of them, it does not. The thing about the 4 that don't work is the Organization ID is higher than the others. Specifically, the ones that don't work, the Organization ID is 2104535684084667442 or higher. The ones that DO work, the ORG ID is 1998894575011238960 or lower.
    The strange thing is if I copy what's in the Address Bar (for ones that give an error) and just paste it in a browser, it works.
    I know there's a limit to what Excel will recognize as a number, but I don't know if that's the issue here or not, because it's just included in the URL string.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Web Query not working for one ID, but is for another

    One thread per issue, please - the rule is for EVERYBODY.

    Continue here: https://www.excelforum.com/excel-gen...-web-page.html
    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.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Web Query not working
    By grcshekar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2021, 10:14 AM
  2. Web Query not working
    By grcshekar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2021, 02:38 AM
  3. Power Query - can I make my query working faster?
    By afgi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-13-2020, 03:41 AM
  4. Web Query not working
    By GrettaF in forum Excel General
    Replies: 1
    Last Post: 10-05-2017, 12:53 PM
  5. Update Query Not Working. "Operation must use an updateable query"
    By jdgwebdev in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-19-2013, 01:19 PM
  6. Help me get an old VB web query working
    By DublinMeUp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2012, 10:02 AM
  7. SQL Query in ADO not working
    By Vikxcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2008, 06:19 PM

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