Convert string array of key-value pair to array of objects javascript

Question

The response I get from API is like this:

"1012": "[{oId=151, oName=store city}, {oId=247, oName=customer city}]"

I want to convert the output's value to array of objects like below:

[
    {
      "oId": 151,
      "oName": "store city"
    },
    {
      "oId": 247,
      "oName": "customer city"
    }
]

Can you please help me in how to do this in JavaScript?

Can you share with us your attempted solution, we can help from there — Isaac
– Isaac, Commented Aug 25, 2021 at 6:16
Your only solution would be to parse it with Regex, but you must know all possible values (e.g. how , in middle of string looks like). OR contact API provider and ask to return proper JSON response — Justinas
– Justinas, Commented Aug 25, 2021 at 6:17

rap-2-h · Accepted Answer · 2021-08-25 06:30:04Z

2

Since the response is not a JSON and we don't exactly know the specification of the API response (is there a spec for this kind of return?), you can try to parse it with a dirty hack.

const str = "[{oId=151, oName=store city}, {oId=247, oName=customer city}]";

const result = JSON.parse(
  str.replaceAll(", ", ",")
     .replace(/([^,{]+)?=([^,}]+)?/gi, `"$1":"$2"`) // Sorry.
);

Result will return:

[
    {
      "oId": 151,
      "oName": "store city"
    },
    {
      "oId": 247,
      "oName": "customer city"
    }
]

Please note that it will fix your actual issue, still:

It will not work in all cases (if there is coma in string or double quote somewhere.
I strongly advise that you contact the API designer since they created a super exotic format that does not scale at all.

answered Aug 25, 2021 at 6:30

rap-2-h

32.3k49 gold badges190 silver badges281 bronze badges

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

1 Comment

sb29595 Over a year ago

Thanks for the hack, but sadly I'm also the backend guy, I don't have other option apart from this response.

dina · Accepted Answer · 2021-08-25 06:42:29Z

You will need a custom parser for this since the it is a string and it does not conform to JSON format. Following snippet might help you:

const data = {
  "1012": "[{oId=151, oName=store city}, {oId=247, oName=customer city}]"
}

function parseCustom(str) {
  const regex = /(\w+)=(.*?)([,}])/gm;
  const subst = `"$1":"$2"$3`;
  return str.replace(regex, subst);
}

const parsedData = JSON.parse(parseCustom(data["1012"]))

console.log(parsedData)

The solution above uses regular expression to replace = with : and does some other basic replacements to make it look like JSON. The solution above will still treat the numbers as string as its inside quotes. The snippet below loops through the array and converts if any valid number is present in values of the object. Run the snippets to see if it matches your requirements.

const data = {
  "1012": "[{oId=151, oName=store city}, {oId=247, oName=customer city}]"
}

function parseCustom(str) {
  const regex = /(\w+)=(.*?)([,}])/gm;
  const subst = `"$1":"$2"$3`;
  return str.replace(regex, subst);
}

const parsedData = JSON.parse(parseCustom(data["1012"]))

// parse values as numbers if its valid Number
// assumes that the parsedData is an Array

const parsedDataNumber = parsedData.map(d => {
  for (let key in d) {
    if (Number(d[key])) {
      d[key] = Number(d[key])
    }
  }
  return d
})

console.log("Number parsed")
console.log(parsedDataNumber)

Collectives™ on Stack Overflow

Convert string array of key-value pair to array of objects javascript

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related