Is it possible to retrieve all information present in DQ+ users page using a REST API node in an analysis and store the same in an internal data store. If yes, could you please provide a URL so that we can retrieve the information present in users page.
Nordea sends an excel file which would contain information of around 8k users such as email, first name, last name and Employee ID, etc.
We convert this information into json format and then update the User profile in DQ+ using REST API call.
However, in the file they send, there are chances that cases of email id's can change which in turn would result in user profile not getting populated as the same email id is not present in DQ+ users page.
Nordea wants a case insensitive lookup on email id, like even if the email mentioned in spreadsheet is Johndoe@Infogix.com and the one present in DQ+ users page was email@example.com, they still want to populate the user profile.
What we thought was to get information present in DQ+ users page using REST API call, store it in an internal store.
Then, in the next analysis, we'll have 2 data sources, one with external data store that reads the excel file provided by Nordea and the other internal store which retrieved the data from users page. Create 2 new fields on 2 data stores and convert both email id's into lower case.
Perform lookup on converted email addresses in both stores and carry forward the original Email ID from DQ+ users page.
Convert this information into json format and then populate the User profile in DQ+ using REST API call.
Please sign in to leave a comment.