Json import fails both local and remotely

Hello, I'm using the latest vData version on the latest Joomla version (3.6.5) and I'm experiencing issues on importing data from a remote server (json API).

I successfully created a profile, selected it on the import panel, then specified and url with parameters and login/password (http://username:password@myDataToBeImported.com/parameters... this url works and gives back a valid son when called by browser) when I go on to import, it goes on the next page "Import details" where I deselect quick import and chose "load fields", it loads my local DB columns but nothing is really loaded from the remote one: I can't select any remote columns.

Same thing happens if I try the same procedure uploading a .json file (attached).



Please let me know if I'm doing something wrong or if there's a known bug (I'm using mac and tested with both the latest Safari and the latest Chrome).

Thank you.

Hello Davide,
I checked the JSON file you are trying to import. It contains a single Object only. While you are expected to import an array of objects even if It's a single record. You need to put that within the brackets []

If you still find some issues, Please share your backend & FTP login credentials via contact us form, We'll look into it.

Thank you for looking into this.

do you mean I have to add that [] in the remote url field?
Something like http://username:password@myDataToBeImported.com/parameters/[1]


Thank you

No, It needs to be added in JSON output which contains the actual data.

I'm calling an API service that it's not managed by me.
I called a list of objects (2) and attached is what I receive. I see [] around "Progetti" but it's still not working with vData.

Any ideas?
Alternatively can you provide a json example that works with vData?

Thank you

Hello,
You can export any profile data in JSON format to have a look at it. And we can make the necessary changes in the script to allow you import data in same format. Please share your backend & FTP login credentials, We'll look into it.