Join Free
+ Reply to Thread
Page 1 of 7 1 2 3 ... LastLast
Results 1 to 10 of 62
  1. #1

    Export a CSV file from our api

    Most of you may not be aware, but you can export a CSV from our system by simply adding a couple parameters to your api request. Almost all of our endpoints support this functionality, so you can export product datafeeds, coupons, even trend data. The parameters are in the api docs at the very top of each endpoints page:
    PHP Code:
    CSV Export URL
    http
    ://api.prosperent.com/api/search/export/myfilename.csv
    With export URLsyou can simply add
    /export/<myfilename>.csv
    To 
    use gzip or zip compression
    /export/<myfilename>.csv.gz
    or
    /
    export/<myfilename>.csv.zip 
    With a current api limit of 1,000 results per query, you should be able to get what you need. Look for us to build an interface to make this easier in the future.

    Here are a few examples:

    PHP Code:
    http://api.prosperent.com/api/search/export/test.csv.gz?api_key=a534d51714fbe7bc4e93231908e4bac1&query=shoes&visitor_ip=127.0.0.1&limit=100 
    The above url will export a gzip compressed csv with a query of shoes and a limit of 100

    All you need to do to create your own csv is replace the api key highlighted below with your own from our interface. This will ensure that all generated CSV files have YOUR Prosperent userid in them:

    http://api.prosperent.com/api/search...sv.gz?api_key=a534d51714fbe7bc4e93231908e4bac1&query=shoes&visitor_ip=127.0.0.1&limit=100
    &query=shoes is where you set the query to search

    &limit=100 is where you set the number of records you want to get back in your CSV.

    You can of course add lots of different filters to your queries to get back more precise results. If you wanted to limit the results to a particular merchant you could use:

    &filterMerchant=zappos.com

    Here is a full list of filters you can use. These are all available in our api documentation. If you are pulling coupons, you can view the list of coupon filters, travel filters for the travel endpoint, etc.
    PHP Code:
    filterBrand
    filterBrand
    =Filter by brand

    filterCatalogId
    filterCatalogId
    =Filter by catalogId

    filterCategory
    filterCategory
    =Filter by category

    filterCelebrity
    filterCelebrity
    =Filter by celebrity

    filterKeyword
    filterKeyword
    =Filter by keyword

    filterKeywords
    filterKeywords
    =Filter by keywords

    filterMerchant
    filterMerchant
    =Filter by merchant

    filterProductId
    filterProductId
    =Filter by productId 

  2. #2
    BTW, I've played around with this and the functionality is broken for the coupons, travel, & deals APIs as far as I can tell. I know the products, merchants, and brands definitely works according to the API documentation.

    I think the API docs need updating for coupons, travel, & deals also.

    from: http://api.prosperent.com/api/specif...myfilename.csv

    to: http://api.prosperent.com/api/search/specific-endpoint/export/myfilename.csv

  3. #3
    Good catch. For coupons it should be http://api.prosperent.com/api/coupon...myfilename.csv

    I'll make sure that gets updated in the next round.

  4. #4
    If you have a compelling reason for it, pm me and I can raise your export limit to 10,000 records per request. We're keeping the number of people with this access to a minimum though since it is so resource intensive.

  5. #5
    Did the API limit get reduced to 100?

    I ran a query yesterday and pulled back 1000 records but today I can't get more than 100.

  6. #6
    It appears to be back to 1000 again this morning!

  7. #7

  8. #8
    Can someone please post here the url for downloading lets say 500 products from a specific merchant (example zappos)

    thx

  9. #9
    Definitely, that's an easy one:

    http://api.prosperent.com/api/search...ant=Zappos.com

    Searches for shoes from Zappos.com with a limit of 500

  10. #10
    Ahhhh thx
    i found my error i wasnt putting the query

    Do i have to put always a query?

    Lets say i want all products (or at least 1k) from a merchant? Can i do something? (i know we have a limit of 1000 records)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
coupons | coupons and deals