curuser marker in webhook using API_ImportFromCSV

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
I have a webhook using API_ImportFromCSV that populates fields in an audit log table triggered by the deletion of one or more records in the main table. It works great, except for one problem. I am trying to capture the name of the user that deleted the records. When using a field I can add the '.csv' suffix to properly format the data. I don't know how to do this with a marker, like curuser. Thus, I get the user's name followed by the extra characters I would get with a field were I had forgotten to add the '.csv' suffix.

What is the proper way to grab the name of the user that performed the delete?
Photo of kpmcdona

kpmcdona

  • 112 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Danie Grabe

Danie Grabe

  • 172 Points 100 badge 2x thumb
Good day kpmcdona,

I had to create a similar webhook today and found that curuser always equals the webhook owners' name and userid. The only way for me to get this to work was to use new.Last Modified By. Here is a section of my webhook to illustrate:

<qdbapi>
<usertoken>{your token will go here}</usertoken>
<skipfirst>0</skipfirst>
<clist>3.116.115</clist>
<records_csv>
<![CDATA[
%RepeatOn%
[Record ID#],[new.Last Modified By],%curdate%
%RepeatOff%
]]>
</records_csv>
</qdbapi>
Photo of kpmcdona

kpmcdona

  • 112 Points 100 badge 2x thumb
Yes, 'new.Last Modified By' is how I handle this in other cases. Sadly, if the record is deleted there doesn't appear to be a value in that field so the value that gets captured is blank/null.