JSON file data can be connected to via PowerShell.
For JSON file sources there are a number of settings:
Fields /Link buttons
|
Folder or web site / Browse |
Specify UNC folder path or http/ftp site address |
|
File type filter |
Optional filter used in combo box listing files in folder |
| Timeout (not implemented for JSON) | Enter the number of seconds to wait for a result from the source when executing source scripts (applies to previews and transfers).
Caution: Setting timeout to 0 is not recommended as it does not automatically free up resources when the source query does not return. |
| Row limit (not implemented for JSON) | Enter the maximum number of rows returned in data previews.
Caution: Setting row limit to 0 is not recommended as data previews might consume a lot of system memory resulting in poor performance or "System out of memory" error messages. |
Note!
Some complex and/or large JSON Files can have some issues being read directly. In these cases the user can specify a custom PowerShell source script.