Comments (4)
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.
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.
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 createdis_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.
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)
- Define APIs for tables HOT 3
- API to check if a unit has been created HOT 4
- API to create a new unit HOT 17
- API to edit an existing unit HOT 3
- API to add a user to a role in a unit
- API to remove a user from a role in a unit
- API to edit an existing user HOT 1
- API to check the list of possible unit types HOT 8
- API to retrieve the list of country codes HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from enterprise-rest-api.