Lukket

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

Færdigheder: Power BI, JSON, API

Om klienten:
( 14 bedømmelser ) longueuil, Canada

Projekt ID: #34351688

20 freelancere byder i gennemsnit $207 timen for dette job

(29 bedømmelser)
5.3
(4 bedømmelser)
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 på 1 dag
(8 bedømmelser)
4.3
(8 bedømmelser)
4.1
(7 bedømmelser)
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 Flere

$250 CAD in 2 dage
(2 bedømmelser)
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 Flere

$245 CAD in 3 dage
(1 bedømmelse)
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 Flere

$250 CAD in 5 dage
(0 bedømmelser)
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 Flere

$140 CAD in 3 dage
(0 bedømmelser)
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 Flere

$180 CAD in 2 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 in 6 dage
(0 bedømmelser)
0.0
(0 bedømmelser)
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 in 7 dage
(0 bedømmelser)
0.0
(0 bedømmelser)
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 Flere

$140 CAD in 7 dage
(0 bedømmelser)
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 Flere

$225 CAD på 1 dag
(0 bedømmelser)
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 Flere

$240 CAD in 7 dage
(0 bedømmelser)
0.0
(0 bedømmelser)
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 Flere

$250 CAD in 7 dage
(0 bedømmelser)
0.0