Query a Maria DB

Google Groups archive
1

Hello,

is it possible to make a query (SELECT) on MariaDB with an Orthanc DB to retrive :

AccessionNumber, Study Instance UID and the study ID (I mean the the one retrived with Curl command)

Thanks

Max

2

Well, you can query the DB directly if you wish but we always recommend to use the API instead: http://book.orthanc-server.com/users/rest.html#performing-finds-within-orthanc

3

Sorry what is the syntax error in this query ?

--request POST --url [http://localhost:8042/tools/find](http://localhost:8042/tools/find) --data '{"Level":"Instance","Query":{"AccessionNumber”:”86472”}}'

Biotron spa

4

You use non-ASCII quotes (”) in this query. Try with:

$ curl --request POST --url http://localhost:8042/tools/find --data ‘{“Level”:“Instance”,“Query”:{“AccessionNumber”:“86472”}}’

5

This is what happens :

C:\curl-7.62.0-win64-mingw\bin>curl --request POST --url http://localhost:8042/t
ools/find --data ‘{“Level”:“Instance”,“Query”:{“AccessionNumber”:“86472”}}’
{
“HttpError” : “Bad Request”,
“HttpStatus” : 400,
“Message” : “Bad request”,
“Method” : “POST”,
“OrthancError” : “Bad request”,
“OrthancStatus” : 8,
“Uri” : “/tools/find”
}

Any ideas ?

Max

6

The escaping rules for quotes are different on Windows (that you use) and on Linux (that I use):
https://en.wikipedia.org/wiki/Escape_character#Windows_Command_Prompt

I let Windows users provide the good command line.

7

curl --request POST --url http://localhost:8042/tools/find --data “{"Level":"Instance","Query":{"AccessionNumber":"86472"}}”

8

Thank u very much !

And if I have a system with user authentication, what is the correct syntax for user “test” and pw “test1” ?

I mean like :

http://localhost:8042/osimis-viewer/app/index.html?user=test&password=test1&study=b610a703-ae8920e6-61753a51-9ba91ecc-1f72674a

(but this do not work…)

Max

9

Please check the resources on the web about HTTP basic authentication. This is an Orthanc forum, not a general HTTP forum.
http://lmgtfy.com/?q=how+to+pass+basic+authentication+in+url

10

Here would be the corresponding URL:
http://test:test1@localhost:8042/osimis-viewer/app/index.html?study=b610a703-ae8920e6-61753a51-9ba91ecc-1f72674a

If using curl, you can use the “-u” command-line option:

curl -u test:test1 http://localhost:8042/system

HTH,
Sébastien-