3

I need to import some data into a table field.

What's the best way to format the data in my original JSON feed?

I've tried this:

[
    "first value",
    "second value",
]

and this:

[
    {"col1": "first value"},
    {"col2": "second value"},
]

But neither of those JSON formats seems to be importing the data properly.

How should I format my data in JSON, so that it may be imported into a table field?


MORE INFORMATION

I've read these docs, but apparently I'm still doing something wrong.

My current JSON looks like this...

"altTitles": [
    {
        "title": "Morke"
    }
]

Where altTitles is my table field, and title is the only column.

I believe I've properly mapped the field...

mapping

Yet for whatever reason, the table fields are not populating...

empty table

4

You can do this a number of ways, and essentially just need an array-like structure to represent the rows.

"Table": [
  {
    "one": "Option1",
    "two": "Option2"
  },
  {
    "one": "Option3",
    "two": "Option4"
  }
]

This issue might be related to your feed however. In the dropdown, you have <altTitles> eg: - there should be a value from your feed in there. According to your example, you should also be mapping to altTitles/title.

My example above shows:

enter image description here

  • Looks like I had it mapped to altTitles... I didn't even see that altTitles/title was there! Thanks crawf, you're a lifesaver! – Lindsey D May 26 '17 at 23:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.