REST API >> Get a specific transaction
Sanjay Parbhoo
7-1-20
Operating system: Windows
Hi,

Is there a way to get a specific NL Transaction record from the API.


I am trying the following but this won't work as Number is not sortable. You get the following message : the sort field can not be sorted on'.


http://IP:PORT/api/1/TRVc?sort=Number
Aldevinas Katkus
7-3-20
Update note says: Only one field can be sorted on, and only if there is a suitable index, if there is no suitable index the request will fail.
I would vote for the ability to extend this functionality too.
For example retrieving a specific record as:
/api/1/TRVc/201/10000014


or /api/1/TRVc?sort=Number&range=range=201,10000014:201,10000020

to retrieve a range of transactions with IntYc=201 and 10000014<=Number<=10000020

i.e., compound index fields are separated by a slash and fields must be in the order of the key definition:


MainKeyBegin(Number,0);
KeySegment(IntYc);
KeySegment(Number);
Aldevinas Katkus
7-3-20
Just realized, that my suggestion has problems when field contains commas.
Anyway you can sort by date and use filters
Sanjay Parbhoo
7-3-20
Created byAldevinas Katkus08:52 3 July 2020
Update note says: Only one field can be sorted on, and only if there is a suitable index, if there is no suitable index the request will fail. I would vote for the ability to extend this functionality too. For example retrieving a specific record as: /api
Thanks Aldevinas

Unfortunately you cannot update a transaction with a patch call as result. I think you could possibly use filters also to get a specific record.

Yes, I like your idea and hopefully it can be added one day.
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Bror-Erik Kotiranta
Clients have their own cache, and then the server has the shared cache, if you want it kind of black and white. Presense should be there as far as i know...
10:55 7 July 2025
Yavuz Yigiterhan
Hello Paul, That is something only HansaWorld can do. But that would help to understand is that causing the problem and - if so - we fix the issue. Additional information is appreciated. Yavuz...
10:45 7 July 2025