Access nested JSON in React table

Question

I want to display nested JSON data in a react-table.

I tried it like this:

   render() {
    const columns = [{
     //Not Displaying
      Header: 'Owner ID',
      id: 'ownerid',
      accessor: '_links.customer.href.ownerid', // <- i think this is wrong
      Cell: this.renderEditable
    }, 

    {
      //Displaying
      Header: 'Price',
      accessor: 'price',
      Cell: this.renderEditable
    }, {

The data i am getting back and have bound to the table is structured as follows:

[
    {
        "id": 1,
        "date": "20.07.2019",
        "price": 3.2,
        "customer": {
            "ownerid": 1,
            "firstname": "John",
            "lastname": "Johnson"
        }
    }
]

Here i am using the columns array:

import ReactTable from "react-table";

<ReactTable data={this.state.offers} columns={columns} 
          filterable={true} pageSize={10}/>

Binding the data:

fetchOffers = () => {
        const token = sessionStorage.getItem("jwt");
        fetch(SERVER_URL + 'api/offers',
        {
          headers : {'Authorization':token}
        })
        .then((response) => response.json())
        .then((responsteData) => {
          this.setState({
            offers: responsteData._embedded.offers,
          });

          console.log(this.state);
        })
        .catch(err=> console.error(err));
      }

The data i am using after binding:

i use it in a react-table component, i will add it to the question. — M.Dan
– M.Dan, Commented Jul 22, 2019 at 22:36
where is _links.customer.href.ownerid in the data? shouldn't the accessor just be 'customer.ownerid' — John Ruddell
– John Ruddell, Commented Jul 22, 2019 at 22:41
i tried that but that also didn't work. I just postet my last try the '_links_customer.href_ownerid' is from the console when i log the state after binding the JSON. I will add that also to the question. — M.Dan
– M.Dan, Commented Jul 22, 2019 at 22:44
can you just post the exact data set you are using? also what is this.renderEditable, because currently i dont see any issues, when mapping the data — John Ruddell
– John Ruddell, Commented Jul 22, 2019 at 22:45

mababin · Accepted Answer · 2021-09-02 07:06:48Z

9

Check the Accessors documentation. It has several examples for complex data structure. I don't see _links or href in your sample data. So I think that you need just:

accessor: 'customer.ownerid'

The data structure from the console screenshot doesn't match your sample data. And it doesn't seem to contain ownerid. Try accessor: '_links.customer.href' to check whether it outputs anything to the table.

edited Sep 2, 2021 at 7:06

mababin

1934 silver badges16 bronze badges

answered Jul 22, 2019 at 22:47

UjinT34

4,9971 gold badge14 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

M.Dan Over a year ago

I thought that also, should have mentioned that i already tried that. It is still not displaying.

UjinT34 Over a year ago

Data from the console doesn't match your sample data structure.

M.Dan Over a year ago

The data i posted is when i call my API from postman in JSON format. The data i posted is after binding. I edited the question.

vancy-pants · Accepted Answer · 2021-11-11 23:37:56Z

3

I had to access a nested object and display it with some styling, and this ended up working for me:

(Note: I was using typescript, so some of the typing might not be necessary)

{
  Header: 'Thing To Display',
  accessor: 'nested.thing.to.display',
  Cell: ({ row }: { row: Row }) => (
    <p>{row.values['nested.thing.to.display']}</p>
  ),
}

answered Nov 11, 2021 at 23:37

vancy-pants

1,37614 silver badges14 bronze badges

Comments

M.Dan · Accepted Answer · 2019-07-23 00:16:10Z

1

I figured it out.

I called the endpoint "localhost:8080/api/offers" and saved the following response:

"offers": [
            {
                "date": "20.07.2019",
                "price": 3.2,
                "_links": {
                    "self": {
                        "href": "http://localhost:8080/api/offers/1"
                    },
                    "offer": {
                        "href": "http://localhost:8080/api/offers/1"
                    },
                    "customer": {
                        "href": "http://localhost:8080/api/offers/1/customer"
                    }
                }
            }
        ]

there is no customer object

But when i call "localhost:8080/offers" i get:

[
    {
        "id": 1,
        "date": "20.07.2019",
        "price": 3.2,
        "customer": {
            "ownerid": 1,
            "firstname": "John",
            "lastname": "Johnson"
        }
    }
]

i changed the URI in my project and now the number is displaying.

I still don't know why i get data from "../api/offers" but i will research.

answered Jul 23, 2019 at 0:16

M.Dan

5741 gold badge4 silver badges16 bronze badges

1 Comment

John Ruddell Over a year ago

Ah, called the wrong api method :3. I'd look at where you define the api routes on the server and see what that is for if you dont know :)

Collectives™ on Stack Overflow

Access nested JSON in React table

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related