Ditutup

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

Kemahiran: Power BI, JSON, API

Tentang Klien:
( 14 ulasan ) longueuil, Canada

ID Projek: #34351688

20 pekerja bebas membida secara purata $207 untuk pekerjaan ini

(29 Ulasan)
5.3
(4 Ulasan)
5.2
nixtech

Hello Sir I can make a call to API, fetch data and dislay in requested format in a table. I am willing to start right away Please check my profile for work and experience. Regards Hardeep

$160 CAD dalam sehari
(8 Ulasan)
4.3
(8 Ulasan)
4.1
(7 Ulasan)
4.1
Lukwence

Hi, I encourage you to please read this cover letter with a keen interest to give me a chance to help. I am Lukman, I have read your job details, requirements and the process and I am passionate about becoming a part o Lagi

$250 CAD dalam 2 hari
(2 Ulasan)
3.3
anasdsoul08

Hello Sir, -- I am Anas, a data analytic with very good skills in data visualization including dashboard with both static and dynamic graphs in Power Bi, Excel and Google Data Studio. So I can achieve this task perfec Lagi

$245 CAD dalam 3 hari
(1 Ulasan)
0.8
topgradeclubltd

Hi, Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert Dominic and i hope to cooperate with you on your project . CERTIFIED EXPERT I Lagi

$250 CAD dalam 5 hari
(0 Ulasan)
0.0
achillesitachi

Hi, I have understood a part of the requirement and assume it's not just powerquery that you need help but also in building the dashboard as well. I will be able to work on this project in the next 3 days and would lik Lagi

$140 CAD dalam 3 hari
(0 Ulasan)
0.0
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping u Lagi

$180 CAD dalam 2 hari
(0 Ulasan)
0.0
minatharwat46

I'm excited to work with you This is a very common request. I can automate this for you now. I've done this hundreds of times.

$80 CAD dalam sehari
(0 Ulasan)
0.0
datascientist90

I'm a senior Python & ML developer and owner & founder of Dedeoglu Dev Company. Kindly send me a message to get in touch with me, Thanks, Yusuf.

$550 CAD dalam 6 hari
(0 Ulasan)
0.0
(0 Ulasan)
0.0
RabbitFreelancer

Hello, I carefully read the job description and really got interested in this position. I'm interested in talking more about this position. Sincere regards.

$240 CAD dalam 7 hari
(0 Ulasan)
0.0
(0 Ulasan)
0.0
GalaxyDesigns

Hello, I went through and understand your project brief.I'd be happy to dive deeper into your project if you accept my proposal. I can chat whenever you are available. I am a creative wizard with 11+ years of experi Lagi

$140 CAD dalam 7 hari
(0 Ulasan)
0.0
ujjwal1996

Hi, I have read the project requirement and understand that I will have to create a table containing all information which is to be merged by line code and part numbers from 3 different data sources. I have been work Lagi

$225 CAD dalam sehari
(0 Ulasan)
0.0
stampasolutions1

Hello there! As per your Job Post, I know that you are looking for an expert in PowerBI, and I would like to assure you that, I can provide you with complete support in the PowerBI with datasource in JSON. Hope to get Lagi

$240 CAD dalam 7 hari
(0 Ulasan)
0.0
(0 Ulasan)
0.0
ep01teccod

We are experts for more than 7 years in the field of business intelligence. Our team is a winner of InterSystems Grand Prix 2022 with our application of Water Conditions in Europe. We work with different platforms to Lagi

$250 CAD dalam 7 hari
(0 Ulasan)
0.0