Results 1 to 2 of 2

Thread: Export a CSV from the Prosperent API

  1. #1
    Member Prosperent's Avatar
    Join Date
    November 29th, 2009
    Location
    CO, USA
    Posts
    820
    Export a CSV from the Prosperent API
    Several wordpress plugins and CMS's only load data from a CSV file.

    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: Prosperent - Sign In


    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 
    As always, please let me know if you have any questions

  2. #2
    Member Prosperent's Avatar
    Join Date
    November 29th, 2009
    Location
    CO, USA
    Posts
    820
    Quick update to this. We are currently building an interface so Prosperent publishers can log in and build a datafeed quickly and easily without having to bother with an API. I'll post a separate announcement when that is ready

  3. Thanks From:

  4. Newsletter Signup

Similar Threads

  1. Prosperent has 3 new API's you should be using!
    By Prosperent in forum Prosperent
    Replies: 0
    Last Post: October 30th, 2013, 10:14 AM
  2. Prosperent API limit increased
    By Prosperent in forum Prosperent
    Replies: 0
    Last Post: May 30th, 2013, 11:30 AM
  3. Prosperent Datafeed export interface
    By Prosperent in forum Prosperent
    Replies: 0
    Last Post: May 28th, 2013, 09:13 AM
  4. Canada and UK API from Prosperent!
    By Prosperent in forum Prosperent
    Replies: 2
    Last Post: April 30th, 2013, 01:15 PM
  5. Prosperent API
    By Prosperent in forum Prosperent
    Replies: 15
    Last Post: March 10th, 2013, 02:29 PM

Posting Permissions

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