I'm using DRUPAL 7 as my CMS.

I've created a content type as 'CONTENT_TABLE', which includes multiple fields (COLUMNS) as such: CONTENT_ID, CONTENT_NAME, LARGE_THUMBNAIL, ZIP_FILE...

What I want to do is to export the data (each row of the table) into a JSON. I need to use this JSON as an input for another website.

I have tried to look for NODE EXPORT module, but not sure how to export the data into JSON which can be used as is.

Expected JSON: { "ContentItems": [ { "CONTENT_ID": "123", "CONTENT_NAME": "ABC", "LARGE_THUMBNAIL": "C:/LargeThumbnail/ABC.jpg", "ZIP_FILE": "C:/LargeThumbnail/ABC.zip" }, { "CONTENT_ID": "234", "CONTENT_NAME": "PQR", "LARGE_THUMBNAIL": "C:/LargeThumbnail/PQR.jpg", "ZIP_FILE": "C:/LargeThumbnail/PQR.zip" } ] }