I was unable to get a Pipeline to do a multi record operation using the API_ImportFromCSV api. I will need to chdck with Support to see of it's supported yet in Pipelines.
I was able to get the Webhook working though.
The endpoint is the url to the Audit trail table.
https://mycompany.quickbase.com/db/xxxxxxxxx
The Header is QUICKBASE-ACTION is the Key and API_ImportFromCSV in the value.
<qdbapi>
<usertoken>xxxxxxxxxxx</usertoken>
<records_csv>
<![CDATA[
%RepeatOn%
"Reviews", "Review Date", "[old.Review Date]", "[Review Date]","[email of last modified by]", "[Record ID#]"
"Reviews", "Reviewed By", "[old.Reviewed by]", "[Reviewed by]","[email of last modified by]", "[Record ID#]"
%RepeatOff%
]]>
</records_csv>
<clist>9.10.11.12.13.14</clist>
</qdbapi>
In the example above, my target Field's IDs are 9, 10, 11, 12, 13 and 14. But they need to be entered in period delimited format as the clist. Those fields respectively are the table name, then the field name, than the old value than the new value, and then the Record ID#] of the changed record. By having that record ID you can make a report link field on the parent record have it filtered only for audit log records of the correct table which would be hard coded by a filter on the report and then the report link field would only include audit records for the parent. By anyone viewing the parent record would immediately have the audit trail. The report would also be filtered to exclude where the old value in the new value were the same and you would have a nightly process to purge are the Trail records where the old value in the new value is the same.
The purge can be done very efficiently using the API_PurgeRecords API call.