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...