Title: JSON Import trouble
Last modified: August 30, 2016

---

# JSON Import trouble

 *  Resolved [pmdataframetest](https://wordpress.org/support/users/pmdataframetest/)
 * (@pmdataframetest)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/)
 * I have been trying to upload a data table using the url option for a JSON file.
   When the upload is “successful” I keep getting many lines of the warning below:
 * Warning: htmlspecialchars() expects parameter 1 to be string, array given in /
   home/engagemi/public_html/capps/wp-includes/formatting.php on line 3438
 * When it goes through, only the very first cell is populated with “JSON”.
 * I am retrieving the JSON url from followthemoney.org
 * I am not a developer, so very minimal coding/development experience. I have tried
   updating all the plugins, turning them all off and back on, leaving them all (
   except tablepress) off, and changing debug to “true” all to no change.
 * What I am trying to accomplish is to host a data frame that will automatically
   update based on the source information.
 * I can upload CSVs with no problem whatsoever, but using JSON would be ideal.
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643820)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * The JSON format that TablePress can import has to be in a certain structure. 
   Mainly, it should be a an array of arrays of strings. Things like JSON objects
   are not supported.
    My assumption here is that the JSON that you get from that
   website does not follow that structure?
 * Regards,
    Tobias
 *  Thread Starter [pmdataframetest](https://wordpress.org/support/users/pmdataframetest/)
 * (@pmdataframetest)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643821)
 * Thanks for the quick reply. I will have to ask what format the source JSON is
   in.
 * I will get back to you soon, if there is any other pertinent info I should ask–
   feel free to let me know.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643823)
 * Hi,
 * can you maybe post a link to an example JSON file? That should be sufficient 
   for me to determine if it might be compatible.
 * Regards,
    Tobias
 *  Thread Starter [pmdataframetest](https://wordpress.org/support/users/pmdataframetest/)
 * (@pmdataframetest)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643824)
 * [http://api.followthemoney.org/?c-r-id=65857&f-core=1&gro=c-t-id&APIKey=42280115247e19f616ce5890bc0667dc&mode=json](http://api.followthemoney.org/?c-r-id=65857&f-core=1&gro=c-t-id&APIKey=42280115247e19f616ce5890bc0667dc&mode=json)
 * Many thanks,
    Sean
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643828)
 * Hi Sean,
 * thanks! This is indeed a very complex JSON file that needs individual parsing.
   This is more than a simple table (i.e. a two-dimensional array), so that this
   can not be imported directly into TablePress, I’m afraid. Sorry.
 * Regards,
    Tobias
 *  Thread Starter [pmdataframetest](https://wordpress.org/support/users/pmdataframetest/)
 * (@pmdataframetest)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643829)
 * Wuah Wuah.
 * Well thanks for all the help. Any suggestions to use this file? I have seen some
   more complex tutorials, but had hoped to use your plugin.
 * Sean
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643835)
 * Hi Sean,
 * no, sorry 🙁 You’d need to convert the JSON format from that site to a “simple”
   table first, or fall back to the CSV format.
 * Regards,
    Tobias
 *  Thread Starter [pmdataframetest](https://wordpress.org/support/users/pmdataframetest/)
 * (@pmdataframetest)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643836)
 * Tobias,
 * CSV will have to do then.
 * Best,
    Sean
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643839)
 * Hi,
 * yeah, that’s the best approach here then.
 * Best wishes,
    Tobias

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘JSON Import trouble’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [json](https://wordpress.org/support/topic-tag/json/)

 * 9 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/json-import-trouble/#post-6643839)
 * Status: resolved