Skip to main content

Transaction data parsed fields

Updated over a year ago

These data points are parsed in the Salv system. This means you can query the information contained in these data points without having to look at JSON data. If the field is not parsed, this is how you query that data point:

select attributes::json->>'relevant_datapoint' 
from transaction where customer_id=$organisationId
and attributes::json->>'relevant_datapoint'='content'

List of indexed data points:

  • external_id (this is the ID that was sent from your system to Salv)

  • type

  • status

  • timestamp (system will accept queries with 'yyyy-mm-dd' or 'Month dd, yyyy' but NOT dd/mm/yyyy)

  • amount

  • reference

  • sender_name

  • receiver_name

  • receiver_account

  • direction

Did this answer your question?