[ CRUD service ] - Read

[georgev-97]

What product are you having troubles with?

Console

What Console version are you using?

12

Description

Good morning guys,

I have many services that write directly on mongo without setting __STATE__: PUBLIC
the CRUD won't find those entries.
Is there a way to retrieve this entries via the CRUD?

Forcing the variable __STATE__ on insert is way too complex

Actual Outcome

No response

Expected Outcome

No response

[flower-of-the-bridges]

Hi @georgev-97

The CRUD service performs operations over documents having the proper metadata fields (__STATE__ is the one only mandatory).

If it's possible, you should make your services insert your records through the create endpoints provided by CRUD itself, to support the proper metadata.

If you can't edit the services to switch from MongoDB driver to crud service HTTP calls, you can expose these collections by using the MongoDB Views definition provided by the console.

Let's suppose you have a collection named test-coll with a field named test, that is populated by external services.

Then, you can create a MongoDB view named test-view using the same fields (using the import/export feature, it should be easy to have the same data model)

Finally, in the aggregation section, you can choose test-coll and using a $project stage to insert a mock __STATE__ field.

So, you can use the endpoint provided by the view to expose the view rather than the collection, to have a document that is compliant to CRUD Service definitions.

⚠️ Keep in mind that MongoDb view endpoints expose only GET endpoints. If you need to perform updates using CRUD service endpoints, consider using CRUD service to perform all operations over your collections, or update your services to provide the __STATE__ field on insert.

Let me know if you need further assistance on this 😃

Bests
Giovanni

[georgev-97]

Thank you for your response
I think this solution might work for me

Best regards,
George