Uploading JSON file in excel

To upload a JSON file in excel I have to follow some manual steps, to avoid following the steps I have recorded a macro but each time i'm getting an error message as: A query with the name already exists" so each time I have to rename them. Can anybody please help me out with this or suggest any alternative to upload a JSON file.
Jaya SinghAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Nice explanation.. I don't have the slightest clue, what you're trying to do..

But I would use curl or wget for uploading a file, not Excel. And it does no matter, what the file contains.
0
Jaya SinghAuthor Commented:
I have to upload the Json file in excel only.. By Json I mean to say a command from notepad or something which I need to run in Excel.

Hope this clears your doubt
0
Fabrice LambertFabrice LambertCommented:
Guess your macro assume the query never exist and always create it.

It should check for the query existance first.
Alas, without your source, not much we can do.
0
Jaya SinghAuthor Commented:
I have attached screenshots of the steps I need to follow before uploading the file
In simple words i'm trying to build a macro to eliminate manual steps.
Step-1.PNG
Step2.PNG
Step-3.PNG
0
Fabrice LambertFabrice LambertCommented:
Correction to my previous sentence:
Alas, without your source code, not much we can do.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.