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"
      }
   ]
}

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

I want 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 I'm 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"
      }
   ]
}

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" } ] }

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"
      }
   ]
}