mapping of URL parameters to embedded data using lookup table + business rules | XM Community
Solved

mapping of URL parameters to embedded data using lookup table + business rules

  • 31 January 2020
  • 2 replies
  • 62 views

Badge
Hi everyone,

I've got a question about data mapping possibilities in Qualtrics.

We have a survey where we recieve different information via URL parameters. Those URL parameters need to be mapped to embedded data fields.
Currently we use some JS script to map some URL parameters:

`Qualtrics.SurveyEngine.addOnload(function() {
var dict = {
"StoreA": "1",
"StoreB": "2",
"StoreC": "3"
};
Qualtrics.SurveyEngine.setEmbeddedData("DirectRetail", dict["${e://Field/U_DR}"]);
});`

This approach has 2 major drawbacks:

* When we have many different values the dictionary/lookup table becomes very large and confusing
* The lookup table can't be maintained by the client by uploading a table to Qualtrics


We would now need to apply some mapping from 6 URL parameters to 2 embedded data fields. This mapping would need to work using a lookup table (which needs to be uploaded and updated in Qualtrics) and also some sort of business rules (logic sets). This could look something like this:

Source parameters: A, B, C, D, E, F
Target parameters: Y, Z

Lookup table for parameter A:
> key1 --> value1
> key2 --> value2
> ...

Lookup table for parameter C:
> key1 --> value1
> key2 --> value2
> ...

Lookup table for parameter E:
> key1 --> value1
> key2 --> value2
> ...


Business rules:

> If (lookupTable(A) == example1) {
> Y = B
> }
>
> If ((lookupTable(A) == example2) OR (lookupTable(C) == example3) {
> Y = D
> }
>
> ....
>
> if (lookupTable(E) == example4) {
> Z = F
> }
>
> ....

Has anyone experienced similar needs and maybe already found some workaround?
Is any feature like this data mapping currently planned for Qualtrics?

Thank you in advance!

Best regards
Andreas
icon

Best answer by TomG 31 January 2020, 14:34

View original

2 replies

Userlevel 7
Badge +27
This is best handled with web service call to an external database. You just need a web host/server to host the script and database.
Badge
Hi Tom,

thanks for your reply!

The issue is that the mapping table contains sensitive information which mustn't leave the Qualtrics server. Therefore this needs to happen in Qualtrics.

Best
Andreas

Leave a Reply