Data360 DQ+

Hi Team,

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.

Use case:

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 johndoe@infogix.com, they still want to populate the user profile.

Solution:

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. 

Regards,

Abhijith

This isn't possible with the older REST APIs, but in DQ+ 4.1 and newer, it is possible in the DQ+ GraphQL APIs with the query below:

 query{
  users {
    nodes {
      displayName,
      email
    }
  }
}

Hi Gerard,

We're currently in version 3.3.

If we can write a query and retrieve the information using a GraphQL, then GraphQL would definitely be hitting an endpoint to retrieve the results. Do you think that if we mention this endpoint in REST API node, we should be able to retrieve the results from Users page?

Can you please check and let me know if you can get the end point information.

Also, thanks for the GraphQL query, I'll test and check whether I can store these details.

Regards,

Abhijith

The endpoints GraphQL connects with aren't exposed for direct access. DQ+'s available REST API endpoints are covered in our Using Data360 DQ+'s REST APIs article, although there aren't REST API endpoints available for user information.

The REST APIs aren't developed anymore and were fully replaced with GraphQL. There's also a DQ+ API Call node that allows for GraphQL queries to be run mid-analysis.