Terminé

Merge two JSON files into Excel insert modify and then write back to JSON files

Hello all,

I am currently trying to merge two JSON files with VBA and then write them into a data set in Excel. This data set should then be able to be changed and then these changes should be applied. Afterwards everything should be written back into the two original files (Json) with all changes.

Difficulties:

One of the JSON files ("user") is tabular and would have to be correctly aggregated (restructured) before being read in order to combine the matching primary key in the other JSON file.

Can anyone help me here? Do I first have to loop into the JSON file ("user") to restructure it before the import?

Thanks a lot

Marco

Compétences : Excel, Visual Basic, Visual Basic pour les apps , JSON, API

Concernant l'employeur :
( 0 commentaires ) Munich, Germany

Nº du projet : #32662281

Décerné à:

rohitagarberg

hi there, i am expert in vba and in json processing, will process the two files in json, will restructure the first file before merging with second, ready to start now and will be online until done, thanks

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(415 Commentaires)
6.7

26 freelances font une offre moyenne de 90 € pour ce travail

(849 Commentaires)
9.0
(463 Commentaires)
8.3
(259 Commentaires)
8.0
(64 Commentaires)
6.9
VladimirLilenko

Hello! I'm a Excel and VBA expert more than eight years. I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the shortest possible time and with Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(187 Commentaires)
6.8
(461 Commentaires)
6.7
(176 Commentaires)
6.4
(128 Commentaires)
6.1
(20 Commentaires)
6.1
hussainmuzammal4

I am currently trying to merge two JSON files with VBA and then write them into a data set in Excel. This data set should then be able to be changed and then these changes should be applied. Afterwards everything shoul Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(18 Commentaires)
5.3
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(16 Commentaires)
4.6
(11 Commentaires)
4.0
(3 Commentaires)
3.0
andylawsonstatz

Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with json data processing using Excel VBA. All clients call me "Prince of Excel". I promise I will fi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(3 Commentaires)
1.7
sharikmp

Hi Dear I've good expertise in handling json and excel. I can quickly help with this. Let me know if you wish to see demo. Thanks Sharik

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
1.8
yinshu2020

----------------Professional JSON & Excel Expert! Best Result in Time!----------- Dear sir. I've read your project description very carefully. I've extensive experience in , so I believe that I can provide excellent re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
swpnljn1996

First have a query, this data extraction - is it supposed to be done using VBA or I can use other programming languages? Second, I am a veteran in software industry but as a freelancer, this will be my first project. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
AndreiBird

Dear Employer, I'm ready to work on json files merging project. I have strong experience in Visual Basic, Excel, Visual Basic for Apps, JSON, API. Please message me to have the whole idea about your project. Will wait Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(0 Commentaires)
0.0
EngAmr93

Hello Sir/Madam, I wish you a good day/night. I can import the JSON files into MS excel, joining them and converting to JSON format again. I need more details like: - Whether it is a merge (horizontal merge) or an appe Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
arslanmajeed0786

Hello Sir i am expert of VBA Macro sheet .. I read your all instruction and I will cooperate with you and accept your work. Don't worry i will take very short time and will give 100 % perfect work.. Now you can believe Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(1 Évaluation)
0.0