Answer by Brendan · Jun 13, 2016 at 09:14 PM
Yes! In fact, one of the developers using PlayFab - Rich Joslin - created a tool that allows you to import data directly, using Google Sheets. You can access it in our GitHub, here: https://github.com/PlayFab/GoogleSheetsToPlayFab
Answer by Jonathon Mckay · Jun 30, 2016 at 10:50 PM
Thank you for the info, the tool is very simple and super useful (I've already expanded it with what I needed).
One question: it is possible to upload the json file to just add new items instead that completely overwrite all?
Answer by Brendan · Jun 30, 2016 at 10:55 PM
Well, the "upload JSON" is really intended for the workflow of downloading the catalog and editing it for re-upload, but you can also use UpdateCatalogItems. That API adds the items submitted to the catalog in question. For convenience, you could use it via Postman using our Collection from GitHub.
And, of course, you can quickly add items to the catalog by duplicating other items in the catalog using the Game Manager, then modifying the elements you need to for the specific item you're adding.
If you feel an "Upload JSON Additive" would be a useful option in the Game Manager, feel free to add it to the Feature Requests forum, so that others can vote on how useful it would be to them - voting there helps us be aware of which things we've heard about would be of benefit to the largest percentage of our community! :)
Answer by mike · Jan 11 at 02:02 AM
Just a comment on this: If you upload a JSON document that isn't formatted the same as the catalog, then nothing happens. No error message or anything. There should be some information like in Brendan's post above that mentions the intended workflow.
For me, I assumed "Upload JSON" would replace the catalog entirely, which is also different from Brendan's suggestion of an "Upload JSON Additive". I think there are use cases for all 3 of these methods.