Kelkoo

Connecting to the Kelkoo portal is possible via the standard Web connector in Adverity and the Kelkoo web service (REST API). 

STEP 1: CREATE A CONNECTION IN ADVERITY

• Connect > Connections > +Add > Web Connect
  • Name: Add a connection name
  • Authorization method: Cookie Session
  • Username: Kelkoo username
  • Password: Kelkoo password
  • Authorization URL: https://merchant.kelkoogroup.com/uk/j_security_check?j_username={USERNAME}&j_password={PASSWORD}

STEP 2: GENERATE A REQUEST URL IN KELKOO

Depending on the report type you want to obtain, your request URL will vary. Note that not all report types are available in every country: https://www.kelkoogroup.com/kelkoo-customer-service/kelkoo-developer-network/shopping-services/webservices-availability-by-country/

Use the Kelkoo request builder to generate the report you need. You can either use a template or create your own. In order to use the web services you must register as an affiliate with Kelkoo. 

STEP 3: ADD A WEB CONNECT DATASTREAM IN ADVERITY

Once you have a Connection and request URL available, add a new Datastream: 

• Connect > +Add New Datastream > Web Connect
  • Name: Add a Datastream name
  • Connection: Choose the connection created in Step 1
  • URL: Paste the URL created in Step 2
  • Request method: GET
  • Date format: %Y-%m-%d
  • Parser: Excel (.xlsx)
  • Encoding: ISO-8859-1
  • Data key: DATA

OPTIONAL: USING START AND END PLACEHOLDERS FOR FLEXIBLE DATES

Instead of pulling a static report, it is possible to use placeholders for start and end date and choose flexible dates when fetching in Adverity.

This means the URL would end like this:

.....?startDate={start}&endDate={end}