Build PowerBI data source from JSON API

I have a powerBI project with three different data sourcing and then i need to create a table containing all information merged by LINE CODE + PART NUMBER.

First data source:
FTP containing a CSV with LINE CODE AND PART NUMBER to display in table with some information

Second data source:
Copy /Paste table of equivalence for LINE CODE VS BRAND CODE

Thirs data source:
JSON API that will authentificate with an API key and will use second data source to make these query for all lines of first data source:

{
"getAutoCarePartApplications": {
"brandCode": "VARIABLE BRAND CODE",
"partNumber": "VARIABLE PART NUMBER",
"vehicleTypeIds": [
5,
6
],
"baseVehicleFacets": {
"enabled": true
}
}
}


The response will look like this:

{
"total": 18376,
"baseVehicles": {
"total": 6857,
"counts": [
{
"count": 63,
"baseVehicleId": 118751,
"year": 2012,
"makeId": 13,
"makeName": "Subaru",
"modelId": 62,
"modelName": "Impreza",
"vehicleTypeId": 5,
"vehicleTypeName": "Car"
},
{
"count": 61,
"baseVehicleId": 122437,
"year": 2013,
"makeId": 13,
"makeName": "Subaru",
"modelId": 62,
"modelName": "Impreza",
"vehicleTypeId": 5,
"vehicleTypeName": "Car"
},
{
"count": 61,
"baseVehicleId": 128524,
"year": 2014,
"makeId": 13,
"makeName": "Subaru",
"modelId": 62,
"modelName": "Impreza",
"vehicleTypeId": 5,
"vehicleTypeName": "Car"

Then i want it to display in a collumn on that format:

Subaru Impreza 12-14, other vehicle year to year etc...