For more information, please refer to this announcement explaining best practices for getting answers to questions.
Oracle HCM Cloud REST Endpoints best practice - PublicWorkers and Workers
Hi,
I am hoping to get advise on Oracle HCM Cloud REST Endpoints(GET) query best practice. I understand that one best practice is to query specific attribute (fields) instead of getting all the fields. I want to know if this may affect performance
→ if we are querying a lot of fields. Is there any limit on the number of fields to be queried that may affect performance.
→ If we use the fields attributes in combination with with multiple query(q) filters
Query example:
hcmRestApi/resources/11.13.18.05/workers?q=workRelationships.LegalEmployerName!='value' AND workRelationships.LegalEmployerName!='value' AND workRelationships.LegalEmployerName!='value' AND workRelationships.LegalEmployerName!='value' AND PersonNumber='value'