+ Reply to Thread
Results 1 to 3 of 3

Forming a URL with a querystring

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    14

    Forming a URL with a querystring

    http://www.coupons.com/ajax/init/?

    This URL returns json data, that I call from Excel using VBA. It returns the POD data info perfect, but I am trying to expand the URL to also list the json data for the following.
    var pid = GetQueryStringValue ('pid')
    var nid = GetQueryStringValue ('nid')
    var zid = GetQueryStringValue ('zid')

    This is the type of URL I want to form, but I need to know the parameters for the "pid" and "zid" to form URLs other than the one shown below.
    http://www.coupons.com/ajax/init?pid...id=iq37&nid=10

    Thank you very much for any insight someone can provide.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Forming a URL with a querystring

    So where do you get the pid, nid & zid values from?

    As far as I understand the problem, it is just basic concatenation.
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    03-09-2014
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    14

    Re: Forming a URL with a querystring

    Thank you for the response. I know the 3 parameters from the home website
    http://www.coupons.com/coupons/pid=1...d=10&zid=iq37/

    I also know that various websites that use coupons.com as an affiliate have their own parameters assigned.
    For instance this URL returns the json for Walmart's.
    http://www.coupons.com/ajax/init?pid...id=10&zid=vz89

    I am trying to figure out how I can return a query that gives me a complete listing of the 3 parameters.
    The most important parameter is the "zid", which on some older html is also referred to as "campaign".
    If I had a list of the 3 parameters, I can query the different URLs to make a complete list of all coupons available.

    I am fairly certain this javascript contains the info needed to acquire the data I am looking for, but I have not been able to figure out how to create the URL
    to "GetQueryStringValue" for the zid value.
    http://cdn.cpnscdn.com/nv.web/combo/...4d893911fcb.js

    I apologize if my terminology isn't very clear, I sort of just try and teach myself as I go along.

+ 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. Forming String from Selected Items
    By bstubbs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2009, 06:57 PM
  2. forming an IF statement function
    By Tony_t in forum Excel General
    Replies: 5
    Last Post: 01-01-2009, 10:13 AM
  3. pass querystring to Excel
    By qwertyjjj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2008, 08:55 AM
  4. querystring size limit
    By mwalker.excelti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2007, 10:18 AM
  5. Distributing elements forming n groups
    By mrbenit@yahoo.es in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2005, 09:05 AM
  6. Create a hyperlink with querystring from cell
    By Marc Miller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2005, 04:06 PM
  7. Querystring
    By viktor in forum Excel General
    Replies: 1
    Last Post: 04-07-2005, 04:06 PM
  8. help me urgent,how to make single querystring to work for multiple select satatements
    By prabhu_javaly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2005, 04:19 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