I dont understand. Password and ldap is allowed so yes it works; but thats with a hard coded user how can it use iris logged in user?

If you need any help with the example api let me know, annoyingly teams didn't record the audio and i haven't had time to re-record it along with the second version of the code we created

Thanks i had looked at the documentation the insert data from another table and the defining a table from another table. 

Yes the syntax wasn't quite like documentation (was solid normal sql syntax i think) . Still doesn't seem to like it via linked table 

ERROR #5475: Error compiling routine: %sqlcq.SRFT.cls301. Errors: %sqlcq.SRFT.cls301.cls ERROR: %sqlcq.SRFT.cls301.1(19) : <UNDEFINED>parseExtFromNode+1^%qaqcmx *mt("f","1^SAMPLE.TEST") :