GetTransactionChangesBetween - accountsIQ/API-Wiki GitHub Wiki

The GetTransactionChangesBetween method returns a the list of Modified transactions matching a set of other filters specified on the query sent in the request.

The maximum number of records returned per call is 10,000 transactions - if your query returns more rows you'll need to use the "Skip" parameter to get the next page of results.

Parameter List

Parameter Type Description
token String The session token retrieved during authentication.
query WSGetTransactionsByQuery This contains the filter and details of your query.

The query itself follows this structure WSGetTransactionChangesBetweenQuery with the following members:

Name Type Description Mandatory
FromDate DateTime Any transaction must have a transaction date after to this date if given (inclusive). No
ToDate DateTime Any transaction must have a transaction date before to this date if given (inclusive). No
TypesFilter String[] Limits the result set to transactions with a type in the provided list. See TransactionTypes for the list of all transaction types. No
AccountIDsFilter Int32[] Limits the result set to transactions linked to the account IDs (customer or supplier IDs). No
DepartmentIDsFilter String[] Limits the result set to transactions having at least one line bearing any of the given department IDs. No
InvoiceIDsFilter Int32[] Limits the result set to transactions linked to the invoice IDs. No
TransactionIDsFilter Int32[] Limits the result set to transactions linked to the transacion IDs. No
Skip Integer Number of rows to skip. No

Example

C#

Here is an example of a system requesting all transactions Modified or Deleted between the 1st of September 2020 and the 20th of September 2020 with at least one of transaction bearing any of "GENERAL", "OFFICE" department IDs:

Integration ws = new Integration();

String auth = "";// See Authentication page for more
if( auth != null )
{
      var query = new WSGetTransactionChangesBetweenQuery()
      {
            FromDate = DateTime.Parse("2020-09-1"),
            ToDate = DateTime.Parse("2020-09-20"),
            DepartmentIDsFilter = new String[]{ "GENERAL", "OFFICE" }
      };
      var transactions = ws.GetTransactionChangesBetween(auth, query);

      if( transactions.Status == OperationStatus.Success )
      {
            Console.WriteLine(String.Format("Found {0} transactions", transactions.Result));
            foreach(var transaction in transactions.Result)
            {
                  Console.WriteLine(String.Format("Transaction [{0}] for Account {2} on the {3} for amount {5}:", transaction.TransactionID, transaction.AccountCode, transaction.TransactionDate, transaction.ControlAmount));
                  foreach(var line in transaction.LineDetails)
                  {
                        Console.WriteLine(String.Format("\t- {0} on {1} with department {2}", line.Amount, line.GLAccountCode, line.DeparmentID));
                  }
            }
      }
}

See Also

⚠️ **GitHub.com Fallback** ⚠️