Converting a string to JSON in node js?

Question

I am consuming a webservice in node js and it returns me the response in this strange format. I have to extract certain values by passing the key names and I would like to convert the response to a JSON for ease of parsing. How should I go about it ?

This is what I get from the webservice

Data Source=*******;Initial Catalog=****;User ID=*******;Password=
*******;MultipleActiveResultSets=True;Min Pool Size=5;Max Pool Size=5000;Conn
ect Timeout=180;Application Name=*****

I want to extract DataSource , UserID, Password.

Split to pairs with .split(';'), then split each pair to k/v with .split('='). This might be harder if values can include ; and =. — Oleg V. Volkov
– Oleg V. Volkov, Commented Mar 28, 2017 at 9:35

AKX · Accepted Answer · 2017-03-28 10:01:53Z

2

Dario's answer basically does the trick, but it's worth knowing that Node's querystring module does this sort of stuff "for free".

The code

const qs = require('querystring');
const s = `Data Source=*******;Initial Catalog=****;User ID=*******;Password=*******;MultipleActiveResultSets=True;Min Pool Size=5;Max Pool Size=5000;Connect Timeout=180;Application Name=*****`;
console.log(qs.parse(s, ';', '='));

outputs:

{ 'Data Source': '*******',
  'Initial Catalog': '****',
  'User ID': '*******',
  Password: '*******',
  MultipleActiveResultSets: 'True',
  'Min Pool Size': '5',
  'Max Pool Size': '5000',
  'Connect Timeout': '180',
  'Application Name': '*****' }

answered Mar 28, 2017 at 10:01

AKX

171k16 gold badges147 silver badges229 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dario · Accepted Answer · 2017-03-28 09:51:10Z

1

You can easily parse it with String split:

const obj = response.split(';', 2).reduce((json, pair) => {
  const tokens    = pair.split('=', 2);
  json[tokens[0]] = tokens[1];
  return json;
}, {});

You can manipulate it, deleting or extracting values, and finally encoding it in JSON with JSON.stringify(obj).

Note: as Oleg V. Volkov comments, if the source string contains delimeters (';' and '=') in key or value, it will don't work.

edited Mar 28, 2017 at 9:51

answered Mar 28, 2017 at 9:45

Dario

4,0752 gold badges15 silver badges27 bronze badges

Comments

Yuefei Ma · Accepted Answer · 2017-03-28 09:53:28Z

0

If the returned pattern is constant, it can be achieved using regexp:

var result = str.match(/Source=(.*);Initial.*ID=(.*);Password=(.*);Multiple/)

And then take your desired values from matched groups.

DataSource = result[1];
UserId = result[2];
Password = result[3];

answered Mar 28, 2017 at 9:53

Yuefei Ma

1711 silver badge5 bronze badges

Collectives™ on Stack Overflow

Converting a string to JSON in node js?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related