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
Piotr Wycichowski
Thanks Gatis, anyway it seems to be reported as bug instead of wish because now it depends on who created task for whom, am I right? /Piotr W....
14:39 15 May 2024
Aldevinas Katkus
Actually a new version of this bug is SL&gt;&gt;Reports&gt;&gt;Periodic customer statement &quot;accumulates&quot; amounts Not sure why it was duplicated, I clicked &quot;submit&quot;only once....
08:09 10 May 2024