User Import preprocessor configuration issue

[Community_User]

Originally posted on May 11 2020 at 15:37 UTC

Hello All,

I am working on import pre-processor configuration for the CSV file based user import. I would like to know how does the pre-processor picks up the 'current' user record which is being processed for modification.

As given below, I am preparing the data for preprocessing. Here USER_ACCOUNTS data returns more than one record which is expected however how do I pass the single record from the list to the preprocessor query based on the current user being processed.

"ADDITIONALTABLES":

{

"USERS":"SELECT USERKEY FROM USERS",

"ACCOUNTS":"SELECT ACCOUNTID,ACCOUNTKEY,ENDPOINTKEY FROM ACCOUNTS WHERE ENDPOINTKEY=5",

"USER_ACCOUNTS":"SELECT * FROM USER_ACCOUNTS"

},

Thanks,

Pallavi

[Community_User · Accepted solution]

Originally posted on May 11 2020 at 15:40 UTC

Purpose of Additional Tables is to prepare dataset on which preprocessor queries will be run.

[Community_User]

Originally posted on October 13 2020 at 04:31 UTC

How many additional tables is exposed into the preprocessor JSON?