REST Api >> Able to sort by index
Liina Saar
1-22-21
Operating system: macOS
There is an update note >>>

"From Dev 8.5 2020 12 21 b316 ->

Bug fixed/feature added:
REST API >> Cannot sort by Index that is not the sames as a field name

Added "keyname=ActCodeForSale"


If you specify sortfield it works as before

If you specify keyname and sortfield it will use the key "keyname" and apply any "range" argument to "sortfield"
if you specify only keyname then "range" should not be specified and is not available

What worked before:
http://hostname.domain.top/api/1/INVc?sort=Group


What is now added (example)


curl --user SJ:Sample99 -X GET 'http://localhost:5557/api/1/INVc?sortfield=ActCodeForSale&&fields=Code,Name'
you have the example as txt for the above from and the original.

original.txt -> how it looked before
test.txt -> how it looks like with sorting (simplified)"

Is there more specific manual or other documentation about this?
How is working sortfield and what is ActCodeForSale?
Bror-Erik Kotiranta
1-29-21
Hello Liina,

only documentation that i know exists (written down) are

https://partners.hansaworld.com/restapi-docs

http://www.hansamanuals.com/main/mailnumber___61173/theconf___1145/shortcode___HW0801TECH_REST_API/hwconvindex.htm

https://hansaworld-web.s3.amazonaws.com/university/university/Webinars/2018/HW%20web%20api%20and%20Oauth2%20with%20standard-id.mp4

https://hansaworld-web.s3.amazonaws.com/university/university/Webinars/2017/Rest%20API.mp4

Br, Bror-Erik

Kristaps Žogots
1-29-21
I think there is one confusing part:

At first it's written:
Added "keyname=ActCodeForSale"
---------
Then later in the example you use "sortfield":
http://localhost:5557/api/1/INVc?sortfield=ActCodeForSale&&fields=Code,Name

Should we use "keyname" or "sortfield"
Bror-Erik Kotiranta
2-2-21
Hello,

seems like i´ve overlooked something. Need to review the update note. But i think it is

curl --user SJ:Sample99 -X GET 'http://localhost:5557/api/1/INVc?keyame=ActCodeForSale&&fields=Code,Name'

Please come back to me and i will update the update note
Br, Bror-Erik
Kristaps Žogots
2-5-21
Does this support AppendFieldToKeyName (and maybe AppendListFieldToKeyName or AppendMatrixFieldToKeyName) with "range" parameter as well?
Let's say you have an index:
KeySegment(LangCode);
SubsetKeyBegin2(LangCode);
AppendFieldToKeyName(TutorialCode);
KeySegment(LangCode);
KeySegment(Heading);


Can I use range to specify TutorialCode or only LangCode?
Bror-Erik Kotiranta
5-17-21
I´m afraid you need to ask erik for this one
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
Ibrahim Bashir
Hello, Auto Scan Import folder is ticked. with multi-company database how to tell the file to which company to be imported? is there somewhere to tag the company where the file to be imported? ...
08:08 28 Mar 2024
SoftIQ Technologies Ltd.
Hello, Our client who has a new contract is trying to access there old database but it gives an error when you try to open the system "window is blocked while license is shut-down ProgressWCla...
07:15 27 Mar 2024