Mila Shvets 1/28/2022 9:07:39 AM
I built the example in the "Import JSON or XHML Files" database free trial.
You'll receive the invitation to this example.
The main idea is the following:
In the "Files" table keeping records with File Attachments (.json or .xml files) I adjusted two custom buttons.
Each button sends files to created "JSON Webhook" or "XML Webhook" respectively.
These webhooks generate records in separate tables.
In the example the "JSON Webhook" generates records in the "JSON Webhooks" table, the "XML Webhook" - in the "XML Webhooks" table.
The custom buttons only demonstrate how the webhooks work.
You may read more about Webhooks here https://www.teamdesk.net/help/15.14.aspx
In your database you can collect invoice files (.json or .xml files) in the Mailbox table.
The Mailbox table can comprise a Record Change trigger with Call-URL action sending file data into webhook.
After that the webhook can create a record in a separate table.
More info on the Mailbox table you may read here https://www.teamdesk.net/help/15.5.aspx
If you don't want to use the Mailbox table, the files can be sent directly to webhooks created in your database, but in this case you will need more complicate programming.