Concluído

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

Habilidades: Excel, Visual Basic, Visual Basic para Apps, JSON, API

Acerca do Empregador:
( 0 comentários ) Munich, Germany

ID do Projeto: #32662281

Concedido a:

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

€100 EUR em 1 dia
(415 Comentários)
6.7

26 freelancers estão ofertando em média €90 nesse trabalho

(849 Comentários)
9.0
(463 Comentários)
8.3
(259 Comentários)
8.0
(64 Comentários)
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 Mais

€65 EUR in 2 dias
(187 Comentários)
6.8
(461 Comentários)
6.7
(176 Comentários)
6.4
(128 Comentários)
6.1
(20 Comentários)
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 Mais

€120 EUR in 4 dias
(18 Comentários)
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 Mais

€100 EUR in 2 dias
(16 Comentários)
4.6
(11 Comentários)
4.0
(3 Comentários)
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 Mais

€50 EUR em 1 dia
(3 Comentários)
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

€50 EUR em 1 dia
(2 Comentários)
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 Mais

€200 EUR in 7 dias
(0 Comentários)
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. Mais

€70 EUR em 1 dia
(0 Comentários)
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 Mais

€120 EUR in 2 dias
(0 Comentários)
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 Mais

€65 EUR em 1 dia
(0 Comentários)
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 Mais

€30 EUR em 1 dia
(1 Comentário)
0.0