I would suggest using Athena. QuickSight does not parse JSON in the best format and is pretty limited. Athena will allow you to create easy datasets with CSVs & JSON.
In regards to your manifest file it seems as though the format should be a CSV because that’s what the file format is.