Fetching PDF attachments associated with transactions

[Elling Bjåstad]

Hi,

When using generalLedgerTransaction to fetch a list of transactions, if I then want to fetch PDF attachments associated with one of the transactions, afterwards, how do I go about it?

[omelhus]

It would be helpful if the resolution could be posted here as well.

[Marius Bancila · Accepted solution]

I suppose it can be done in different ways. This is an example, starting from the transaction (but you can also query directly from the mentioned tables):

query purchase_order_line(
  $cid : Int!, 
  $filter :FilterExpression_GeneralLedgerTransaction)
{
  useCompany(no : $cid)
  {   
    generalLedgerTransaction(filter : $filter)
    {
      items
      {
        voucherJournalNo
        auditNo
        
        incomingAccountingDocumentNo
        
        joinup_IncomingAccountingDocument
        {
          incomingAccountingDocumentNo
          incomingAccountingDocumentType          
          
          joindown_IncomingAccountingDocumentAttachment_via_IncomingAccountingDocument
          {
            items
            {
              attachmentNo
              attachmentType
              fileNo
              fileName
              fileData
            }
          }
        }
      }
    }
  }
}

[Marius Bancila]

I understood this problem was resolved with the support team.

[Elling Bjåstad]

Yes, that's correct.

The answer is that attachments can be fetched through incomingAccountingDocument and incomingAccountingDocumentAttachment, using incomingAccountingDocumentNo as the key. This will fetch attachments that are stored directly in the Visma Business NXT database, which is the legacy way of storing attachments. In addition there's a new method for storing file attachments that uses an external file storage service. This method is currently not supported by any customer facing API, says the Visma Business NXT support team.