Rest API - adding users/contacts to the sys_user table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024 07:18 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 01:57 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 02:35 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 12:19 AM
Thank you very much Kieran.
Best regards,
ken