nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How can I filter documents returned via the REST automation API?

mikejt4_

I'm attempting to retrieve a selection of documents from a Nuxeo server using the REST automation APIs (from C++ using libCURL). I'm new to Nuxeo, so I'm trying to 'prototype' the calls using CURL from the command line. We've defined some custom document metadata called a Plate which has a manufacturer field.

The following works in the shell, returning two plates named 1 and 2 from a collection; query "SELECT * FROM Document WHERE plate:manufacturer = 'Oxoid'" /default-domain/workspaces/testing/collection/1 /default-domain/workspaces/testing/collection/2

But if I execute this inside a CURL request, it gets confused; curl -H 'Content-Type:application/json+nxrequest' -X POST -d '{"params":{"query":"SELECT * FROM Document WHERE plate:manufacturer = 'Oxoid'"},"context":{}}' -u Administrator:Administrator http://localhost:8080/nuxeo/site/automation/Document.Query

This fails with a page of java exception, but ultimately says "No such property: Oxoid"

Find more posts tagged with

Comments

mikejt4_

Formatting out libCURL strings doesn't seem like a particularly nice option either ... can anyone suggest a better way to use Nuxeo from C++?

mikejt4_

Ah well I figured it out eventually - well, I'm using a different command that works:

curl --trace-ascii dump.txt -H 'Content-Type:application/json+nxrequest' -X POST -d '{"params":{"property":"plate:manufacturer","values":"Oxoid"},"context":{}}' -u Administrator:Administrator http://localhost:8080/nuxeo/site/automation/Document.FetchByProperty

...does the trick. Not sure why, but Document.FetchByProperty just seems to work better than Document.Query.

Laurent_Doguin

Looks like it maybe a simple quote escaping issue.

curl -H 'Content-Type:application/json+nxrequest' -X POST -d '{"params":{"query":"SELECT * FROM Document WHERE plate:manufacturer = 'Oxoid'"},"context":{}}' -u Administrator:Administrator http://localhost:8080/nuxeo/site/automation/Document.Query

mikejt4_

Same error -