Difficulty importing JSON via URL

  • Resolved amowers1

    (@amowers1)


    7 years, 9 months ago

    I apologize for asking this question, but I could not find a JSON example URL to do this test. My server is generating JSON and I cannot get TablePress to import that JSON via a URL. I see the error “Error: The source for the import is invalid or could not be accessed.”

    For example, the file at this URL contains JSON I cannot get to load:
    https://testapi.talktalk.ch/test.html

    Can someone provide me with a URL to JSON that does load into TablePress?

    Thanks
    Tony

    • This topic was modified 7 years, 9 months ago by amowers1.
    • This topic was modified 7 years, 9 months ago by amowers1.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    This JSON format (an array of arrays of strings) is totally correct.

    In this case, the issue seems to be with the SSL encryption of the testapi.talktalk.ch server. When I try the import on my test site, I have this error:

    cURL error 35: Unknown SSL protocol error in connection to testapi.talktalk.ch:443

    I’m not an expert with that cURL library (this is the program that downloads the file from the remote server), but from what I understand, it did not like something about the SSL encryption. I assume that the same happens on your server.

    I can therefore only suggest that you try a different remote server or check with that server’s admin about the SSL settings.

    Regards,
    Tobias

    Thread Starter amowers1

    (@amowers1)

    Hi Tobias,

    Thank you very much for your reply. We’ll send a donation your way and we’ll also be purchasing the premium extension that does scheduled updates of the tables.

    I’ve resolved the issue. It turns out there were two causes of the problem:

    1) The SSL problem that you pointed out. My client’s firewall appliance is old and it uses an older SSL protocol version.
    2) The WordPress host machine could not resolve the DNS name because our ‘api’ domain is a subdomain of the WordPress website. The hosting service provider hosts the www site and so their local DNS servers were trying to resolve the api subdomain to someplace within their own local network too.

    I thought it was my software generating a bad format or producing http headers which were incompatible with TablePress. Turns-out it was all networking issues. Ultimately I debugged it by SSH on the server and executing a curl command.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    great! Nice find! Good to hear that you were able to resolve these problems!
    And thanks for wanting to support TablePress!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

    hi, i read them but i had have this problem yet.
    when i copy paste json file in manually import is working correctly but when i use url link i have an error : “tablepress import Error The source for the import could not be accessed.”
    ssl is active and the link is public
    please help me

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    silverhorse2525: Let’s keep this discussion at https://www.ads-software.com/support/topic/tablepress-json-url-import-not-working-for-me/ where we already have more details. Thanks!

    Regards,
    Tobias

    • This reply was modified 7 years, 8 months ago by Tobias B?thge.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Difficulty importing JSON via URL’ is closed to new replies.