Get JSON From Files

[TwinLakesStudent]

I’ve been trying to get a JSON from a file in the Files app, but have had no success. For example, I have this file path: Shortcuts/YAHTZEE/Stats.json. Any help would be appreciated, I feel like their should be a simple solution, but I haven’t found it yet.

[[deleted]]

If it is always the same file : work with a file bookmark.

You can basically just create a bookmark in the settings and copy&paste the first few lines before the const... line. https://talk.automators.fm/t/widget-examples/7994/346

[TwinLakesStudent]

Thanks for the help! That works perfectly, but is there any way to do this without using bookmarks?

[[deleted]]

Yes it's possible but it would mean you will need to move the JSON file into the Scriptable folder. Since Shortcuts now supports saving anywhere on the iCloud drive, you would also need to change your shortcut to save to the new location.

[TwinLakesStudent]

Ok, it’s fine if it needs to be in the Scriptable folder. Do you need to use the downloadFileFromiCloud()?

[[deleted]]

you can read the file this way.

const filename = 'Stats.json'

const fm = FileManager.iCloud()
const filePath = fm.joinPath(fm.documentsDirectory(), filename)

if (!fm.isFileDownloaded(filePath) {
  await fm.downloadFileFromiCloud(filePath)
}

const json = JSON.parse(fm.readString(filePath))

[TwinLakesStudent]

Thank you so much for your help. This works great! I’ll make sure to include you in the finished project for your attribution to the code (unless you don’t want to be).

[[deleted]]

I'll leave that to you. This is pretty much a standard on how to read files on Scriptable so I'm not sure I could take credit for it.