Hi Aastha,
Exporting as JSON is not supported.
You can copy a row from explore as json. This is useful for testing API queries to Prediction API endpoints.
You can use a Python recipe and write the JSON to a managed folded and then download the managed by browsing that folder.
import dataiku
import pandas as pd
import numpy as np
from dataiku import pandasutils as pdu
from datetime import datetime
# Read recipe inputs
ticket_search_csv = dataiku.Dataset("dataset_name")
ticket_search_csv_df = ticket_search_csv.get_dataframe()
output_folder = dataiku.Folder("B9rFvU0O")
output_folder_info = csm_json.get_info()
# Get the current date and time
current_date_time = datetime.now()
# Format the date as YYYY-MM-DD-HH
date_formatted = current_date_time.strftime("%Y-%m-%d-%H")
# Create the filename with the formatted date
filename = f"filename_prefix_{date_formatted}.json"
#for local folders for remote folders S3 see get_writer/ upload_stream https://knowledge.dataiku.com/latest/code/managed-folders/tutorial-managed-folders.html
path = output_folder.get_path()
# Save the DataFrame to a JSON file with the updated filename
ticket_search_csv_df.to_json(path + "/" + filename, orient="records"
