WP Data Access JSON only fetching single row

  • Resolved kammerman

    (@kammerman)


    1 year, 4 months ago

    Hello, I’m using the paid (premium) version of WP Data Access – I’ve run into a problem where I can only retrieve the first record from a JSON response.

    I believe this is because the API source data doesn’t have a named “table object”. In the docs I can see the JSON sample has a label “data”, but the source I’m trying to use just jumps straight in – see here: https://api.406registration.com/tac

    If I use “[]” as the “table object” I can see the plugin accesses the field names properly and loads the first record – but I don’t see how to get it to access the remaining records. Any suggestions?

    Thank you!

    Kevin

Viewing 1 replies (of 1 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @kammerman,

    Thanks for the post. Yes, the JSON file needs to have a valid table object in order to pull the rows correctly. ??

    You can possibly copy your JSON file to another public location and then add a table object manually so you can connect it to WP Data Access, but I imagine you’d prefer to connect to the source directly.

    I’ll reach out to Peter about this in case there’s an alternative way. I’ll send a follow-up once I receive feedback.

    We appreciate your patience. ??

Viewing 1 replies (of 1 total)
  • The topic ‘WP Data Access JSON only fetching single row’ is closed to new replies.

Tags