JSON

Question

Post reply

JSON

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
September 5, 2015 at 11:35 am

#100913

Comments posted to this topic are about the item JSON
September 7, 2015 at 12:16 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Heh... the correct answer is "Just Some Other Notation" that doesn't belong in a database. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 3

A slightly awkward question, I think, since both the third option and the fourth option are correct with the question phrased as it is. Should really be phrased to say "what does JSON stand for" or "what phrase was the acronym JSON coined for".

I suspect that the different wording would have led to well over 90% of answers being correct, instead of only ( 😀 ) 78% (so far).

Tom

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Yes, it was simple. It's at 80% now.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

akljfhnlaflkj

SSC Guru

Points: 76202

September 8, 2015 at 3:04 pm

#1825272

I like the first answer best.

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Iwas Bornready (9/8/2015)
I like the first answer best.

But "JSON" is 5 or 6 letters too short for that, because with those first four words it has to be a truncated JSONTBID (with an optional A between I and D) :hehe:

Tom

ManicStar SSCoach Points: 17992 More actions · Answer 7

JSON is evil incarnate. XML's bastard sibling at best.

😀

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 8

Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀

I LOVE IT! A kindred spirit!!!! 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ManicStar SSCoach Points: 17992 More actions · Answer 9

Jeff Moden (9/9/2015)
Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂

My first encounter with it was someone sending me a data feed in it. They said it was 'like xml'.

One large powershell script later to read the thing and stuff its contents into a staging database, I was cursing it. Then I had an epiphany, it has 'java' in its name, we all know who pushes Java on the world, and that is the master bastion of evil and decrepitude.

sknox SSChampion Points: 12388 More actions · Answer 10

Manic Star (9/10/2015)
Jeff Moden (9/9/2015)
Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂
My first encounter with it was someone sending me a data feed in it. They said it was 'like xml'.
One large powershell script later to read the thing and stuff its contents into a staging database, I was cursing it. Then I had an epiphany, it has 'java' in its name, we all know who pushes Java on the world, and that is the master bastion of evil and decrepitude.

Well, there's your problem. You should have used JavaScript, not PowerShell. JavaScript will natively consume JSON. Alternatively, you could have installed SQL 2016 somewhere to parse it. That would probably have taken less time than trying to mangle JSON via PS. 😛

PS. JavaScript has absolutely nothing to to with JAVA (fortunately.)

ManicStar SSCoach Points: 17992 More actions · Answer 11

PS 3.0+ automatically converts a json stream to a powershell object. It actually works quite nicely.

Reminds me I need to finish the article I started writing on this.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 12

sknox (9/11/2015)
Manic Star (9/10/2015)
Jeff Moden (9/9/2015)
Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂
My first encounter with it was someone sending me a data feed in it. They said it was 'like xml'.
One large powershell script later to read the thing and stuff its contents into a staging database, I was cursing it. Then I had an epiphany, it has 'java' in its name, we all know who pushes Java on the world, and that is the master bastion of evil and decrepitude.
Well, there's your problem. You should have used JavaScript, not PowerShell. JavaScript will natively consume JSON. Alternatively, you could have installed SQL 2016 somewhere to parse it. That would probably have taken less time than trying to mangle JSON via PS. 😛
PS. JavaScript has absolutely nothing to to with JAVA (fortunately.)

Whenever possible, I avoid all four. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

christian.jones Valued Member Points: 73 More actions · Answer 13

Manic Star (9/10/2015)
Jeff Moden (9/9/2015)
Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂
My first encounter with it was someone sending me a data feed in it. They said it was 'like xml'.
One large powershell script later to read the thing and stuff its contents into a staging database, I was cursing it. Then I had an epiphany, it has 'java' in its name, we all know who pushes Java on the world, and that is the master bastion of evil and decrepitude.

.

JSON is extremely easy to consume in PowerShell. Lets say you have the JSON values in a string variable named $jsonData. You can convert it to a PowerShell object by simply using the convertfrom-json command (https://technet.microsoft.com/en-us/library/hh849898.aspx).

$myObj = ConvertFrom-Json $jsonData

Done...