[bug] 400 Client Error when fetching Nuxeo collection

[gamontoya]

When re-harvesting a recently, successfully harvested Nuxeo collection, it fails at the fetch_collection phase:

• 28234
• Airflow log

[2024-06-11, 23:39:06 UTC] {{standard_task_runner.py:104}} ERROR - Failed to execute job 140492 for task fetching.fetch_collection (400 Client Error: for url: https://nuxeo.cdlib.org/Nuxeo/site/api/v1/search/lang/NXQL/execute?pageSize=100&currentPageIndex=0&query=SELECT+%2A+FROM+SampleCustomPicture%2C+CustomFile%2C+CustomVideo%2C+CustomAudio%2C+CustomThreeD+WHERE+ecm%3Apath+STARTSWITH+%27%2Fasset-library%2FUCB%2FUCB+Ethnic+Studies%2FAAS%2FWei+Min+She+and+Asian+Community+Center+photographs%2C+1970-1980%2FAsian+Community+Center+Children%27s+Program%27+AND+ecm%3AisTrashed+%3D+0+ORDER+BY+ecm%3Apos; 11642)

[christinklez]

Perhaps due to strange characters in the link. Explore changing the URL to use UUIDs. (May have quotes in the title.)

[barbarahui]

This should be fixed with this PR: #1011

The problematic path has a single quote in it. Querying by ecm:ancestorId rather than ecm:path gets around this problem.

[christinklez]

Thanks so much, @barbarahui! I ran a harvest and it's successfully finished through. Thank you!