ActivityTimeline REST API - in eazybi

[Nada]

I’m working on creating a report in eazyBI with data sourced from a REST API. The goal of this report is to track the velocity versus team hours (capacity) across sprints.
but the endpoint i’m trying to import has a data field type array, for example:

{
   "id":"5648895637201243664",
   "name":"Sample Team",
   "members":[
      {
         "id":"5412165287981567372",
         "involvement":8.0,
         "personPosition":null,
         "userRealName":"Fefofi",
         "email":"person@company.com",
         "enabled":true,
         "username":"63c83eb49d59ec70dddddd",
         "capacity":[
            {
               "day":"2023-02-11",
               "hours":"0",
               "dayOfWeek":"sat"
            },
            {
               "day":"2023-02-12",
               "hours":"0",
               "dayOfWeek":"sun"
            },
            {
               "day":"2023-02-13",
               "hours":"8",
               "dayOfWeek":"mon"
            },
            {
               "day":"2023-02-14",
               "hours":"8",
               "dayOfWeek":"tue"
            },
            {
               "day":"2023-02-15",
               "hours":"8",
               "dayOfWeek":"wed"
            },
            {
               "day":"2023-02-16",
               "hours":"8",
               "dayOfWeek":"thu"
            },
            {
               "day":"2023-02-17",
               "hours":"8",
               "dayOfWeek":"fri"
            },
            {
               "day":"2023-02-18",
               "hours":"0",
               "dayOfWeek":"sat"
            }
         ]
      }
   ]
}

how can i import the array ? please advise

[roberts.cacus]

Hi @Nada,

Go back a step and specify the column “members” as the data path in the REST API source application import options - Import from REST API. The data path could be the following one $.members.

Best,
Roberts // support@eazybi.com