Tamamlanmış

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

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic, JSON, API

İşveren Hakkında:
( 0 değerlendirme ) Munich, Germany

Proje NO: #32662281

Seçilen:

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(415 Değerlendirme)
6.7

Bu iş için 26 freelancer ortalamada €90 teklif veriyor

(849 Değerlendirme)
9.0
(463 Değerlendirme)
8.3
(259 Değerlendirme)
8.0
(64 Değerlendirme)
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 Daha Fazla

€65 EUR in 2 gün içinde
(187 Değerlendirme)
6.8
(461 Değerlendirme)
6.7
(176 Değerlendirme)
6.4
(128 Değerlendirme)
6.1
(20 Değerlendirme)
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 Daha Fazla

€120 EUR in 4 gün içinde
(18 Değerlendirme)
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 Daha Fazla

€100 EUR in 2 gün içinde
(16 Değerlendirme)
4.6
(11 Değerlendirme)
4.0
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(3 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(2 Değerlendirme)
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 Daha Fazla

€200 EUR in 7 gün içinde
(0 Değerlendirme)
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. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
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 Daha Fazla

€120 EUR in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
0.0