MRN conversion using a SQL database for lookup

I am trying to do an MRN conversion on incoming DICOM files using a SQL lookup table.

Can anyone give me help with this?

Thanks

Hello,

Your question is unclear. Orthanc provides no access using the SQL language, but with its REST API:
http://book.orthanc-server.com/users/rest.html

You are presumably looking for the URI “/tools/find”:http://book.orthanc-server.com/users/rest.html#performing-finds-within-orthanc

For instance, the following request will look for patients with given “PatientID”:

curl -X POST http://localhost:8042/tools/find -d ‘{“Level”:“Patient”,“Expand”:true,“Query”:{“PatientID”:“12345678”}}’

Sébastien-