The Code you provided is the JSON schema, and the original data should have an array, so you can use the Apply to each action to add these data into an Excel table by using Add a row into a table action. If you could provide an instance of the JSON, I can make the implementation details more specific, thanks. You run the risk of uploading your data to malicious people when you use a JSON converter online. This app will give you peace of mind knowing that all your data are safe for it converts json to.
- Nested Json To Csv Generic Approach
- Append Json To Csv
- Csv To Json Logic App
- Json To Csv Application
- Json To Csv Desktop App
- Json To Csv Logic App
Nested Json To Csv Generic Approach
Day One has importing options on iOS, macOS, Android. While the importer is not specific to any particular source, we try our best to get your data imported as separate entries. The data in the file you are importing must match what Day One expects. Because of the different export options from other sources, you may have to manually edit the file before importing to Day One.
Please see this guide for importing into Day One on Android.
iOS
On iOS, you can import data from the Day One Classic (version 1) app, JSON files, or CSV files.
Go to Day One > Settings > Import/Export > and choose the option to import.
macOS
On Mac, you can import the following:
Append Json To Csv
Details about the import file types.
See this guide for importing data from the Classic app. Classic file/Classic app.
JSON (iOS, Mac, Android)
Csv To Json Logic App
JSON exports is the manual/export option from Day One. JSON files can contain all entries, media, and metadata. The JSON file format must match what Day One is expecting. On iOS and Android, the JSON file must be stored in local storage in order to import the file. For macOS, it is recommend the file be in the Downloads folder. Click here to download an example file of the JSON export from Day One.
Json To Csv Application
CSV import (iOS only)
Not all headers are required. Only date and text are the required headers for the CSV import. Dates must be in ISO 8601 format. The file needs to have the .csv file extension like myJournalImport.csv. The file will need to be stored on local storage on iOS in the Files app. Click here to download an example file of the CSV export from Day One on iOS.
Plain Text (macOS only).
Media cannot be imported via the Plain Text import. Though, exporting from Day One to Plain Text can include media when the option is selected.
The option for Plain Text requires that each entry must have a date stamp in this format:
Json To Csv Desktop App
Date: June 24, 2016 at 10:59:06 AM MDT
Json To Csv Logic App
See an example below. Note that location or weather are not required for importing. There must be two carriage returns between the date and the entry. Then two more carriage returns between the end of one entry and the next date. Click here to download an example file of the Plain Text export.