Rest API - adding users/contacts to the sys_user table

kydomingo
Tera Contributor

Hello and Good Morning,

 

just inquiring what is/are the best practice in terms if integration (with external sources ) with the sys_user table. We are planning to use REST API to add/update users in the sys_user table however, is this the best practice? Are there any suggested best practice, e.g., creating a temporary staging/import table and then using REST API to add users to a this staging table, then use an import/transform map.

 

thank you very much.

 

best regards,

ken

7 REPLIES 7

Hello and Good Afternoon Sir,

 

Yes...  the current behaviour is that whenever I loaded records to the (staging) import set table, it would automatically be transformed/copied to the target table (sys_user). Is this the expected behaviour assuming that I did not configure any "schedule" for the transformation? would it be possible to upload the records (REST API) and have it sit in the (staging) Import Set table and hav it process (copy to the target table) say daily at 2 am? 

 

Thank you very much.

 

Best regards,

ken

I'm not aware of an option to allow you to do that unfortunately...although I see the benefit and would welcome the feature. I'd recommend raising a support case. Let us know if you come across a solution

Thank you very much Kieran. 

 

Best regards,

ken