Giter VIP home page Giter VIP logo

Comments (4)

kaihendry avatar kaihendry commented on August 16, 2024

wrt returns for #2, #3, #4, #5, #6, #7, we cannot respond whether the set data has been successfully invoked/setup on MEFE et al.

We can respond basically that the data has been written to the table successfully or not. That's it.

As for responding with "MEFE API Key associated to this users and user creator." or "Return timestamp: date and time (Z) when the user was successfully added to the unit.", we can't do that.

Another "check my request API" needs to be documented, where the client has to poll to work out how their set data has been applied. That "check my request API" is how @franck-boullier currently checks his relevant (logging) tables to know whether our asynchronous jobs were successful or not, or yet to be run.

from enterprise-rest-api.

kaihendry avatar kaihendry commented on August 16, 2024

for e.g. next steps here is how to query that given that a new user has been created in the relevant table (what table is this btw?), demonstrate how to find "MEFE API Key associated to this users and user creator.". I.e. what is the SQL query to know that this new user has been created.

from enterprise-rest-api.

franck-boullier avatar franck-boullier commented on August 16, 2024

How the user creation works in UNTE:

UNTE master user insert the user information about user that needs to be created.
As part of this process we will have the following information:

  • external_person_id: the Unique ID of the user in the source system: the system where the user information is coming from (if empty, we use the email address for the user).
  • external_system: System where this information is stored (if empty, we use the default table configured when the UNTE master account was created)
  • table_in_external_system: Table in the system where this information is stored (if empty, we use the default table configured when the UNTE master account was created)
  • organization_id: a unique ID attached to the API key for the Master user for the UNTE enterprise account

After the user creation request is sent to the UNTE:

In the UNTE database the tables that matter is the table ut_map_external_source_users
The query you need is

SELECT 
  `unee_t_mefe_user_id`
  , `unee_t_mefe_user_api_key`
  , `uneet_created_datetime`
  , `is_mefe_api_success`
  , `mefe_api_error_message`
FROM `ut_map_external_source_users`
WHERE `external_person_id` = "[external_person_id]"
  AND `external_system` = "[external_system]"
  AND `table_in_external_system` = "[table_in_external_system]"
  AND `organization_id` = "[organization_id]"
;

This will return a single record where:

  • unee_t_mefe_user_id is a STRING: The MEFE user ID for this user (probably not needed though)
  • unee_t_mefe_user_api_key is a STRING: the API key for this user.
  • uneet_created_datetime is a TIMESTAMP (Z) the date and time when the user was created
  • is_mefe_api_success is either 1 (TRUE) or 0 (FALSE)
  • mefe_api_error_message is a STRING: the error message we received if any

from enterprise-rest-api.

kaihendry avatar kaihendry commented on August 16, 2024

Is organization_id the same as organization_key or is it different?

I'm not clear what table the created user data goes into. persons or external_persons ? table_in_external_system is not in the persons table for e.g.

I don't quite understand "After the user creation request is sent to the UNTE". Is that to give info on the request like #10 ?

from enterprise-rest-api.

Related Issues (10)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.