How do I insert a specific key: value of Json into a postgres table using Node.js

Question

I got a json variable in which i got all my data. I'd like to take a specific key and its value to insert it in a specific column of my table.

Here is an example:

{
    'Code bati': 'Pas',
    Etage: '0',
    Zone: 'FST',
    'Pièce': '000',
    'Priorité': 5,
    'Désignation': 'Salle de cours',
    'Type d’installation': '',
    'Date de mise en service': '',
    "Date d'installation": '',
    Maintenance: '',
    'Entreprise ayant le contrat de maintenan': '',
    'Date de visite': 44525,
    Marque: 'Epson',
    'Modèle': 'EB-1980WU',
    'N° série': 'V5YF630231L',
    'Heure Lampe': 1796,
    Position: 'centré',
    HDMI: 'oui',
    VGA: 'oui',
    Video: 'non',
    Automate: 'MLC ???',
    Liaison: 'RS232',
    'Type écran': 'manuel',
    'Cage sécurité': 'oui',
    'Statut HDMI': 'à tester',
    'Statut VGA': 'à tester'
  },

Here is my array, i'd like to take for example the key 'Zone' and its attribute 'FST' to insert them in a specific table of my postgres database. Do you have a solution for me ?

sql statement : UPDATE your_target_table SET your_taget_column = your_json_data->>'Zone' WHERE your_condition_to select_the_row_to_update — Edouard
– Edouard, Commented Dec 16, 2021 at 10:25

Lior Kupers · Accepted Answer · 2021-12-16 10:28:41Z

1

It is a bit unclear to me if you have already installed PG lib for node. I have used this one in the past (when I needed something simple and fast): https://www.npmjs.com/package/pg.

Anyways, let's say you have this JSON in a variable, then you would like to parse that into an object, and then you can pick and choose whatever you want, and insert into the db.

Btw, your JSON is not formatted correctly, it is already formatted as an object... in the yourJSON var below I have formatted it correctly for you (by taking what you had, and wrapping it with JSON.stringify(whatYouHad))

const yourJSON = '{"Code bati":"Pas","Etage":"0","Zone":"FST","Pièce":"000","Priorité":5,"Désignation":"Salle de cours","Type d’installation":"","Date de mise en service":"","Date d'installation":"","Maintenance":"","Entreprise ayant le contrat de maintenan":"","Date de visite":44525,"Marque":"Epson","Modèle":"EB-1980WU","N° série":"V5YF630231L","Heure Lampe":1796,"Position":"centré","HDMI":"oui","VGA":"oui","Video":"non","Automate":"MLC ???","Liaison":"RS232","Type écran":"manuel","Cage sécurité":"oui","Statut HDMI":"à tester","Statut VGA":"à tester"}';

const parsedJSON = JSON.parse(yourJSON);

const query = 'INSERT INTO your_table (zone) VALUES ($1);
const bindings = [parsedJSON.Zone];
const insertResult = await dbClient.query(query, bindings);
console.log(insertResult);

You would need to clarify some more otherwise...

answered Dec 16, 2021 at 10:28

Lior Kupers

9179 silver badges20 bronze badges

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

2 Comments

bbelmo01 Over a year ago

Well, i tried your code and it works pretty fine so thank you. I might not have been really clear in my explanations and i'm sorry for that. I try to create a script and i'm not always understanding of what am i doing so... it's quite hard to be clear. Anyway, thank you for your help

Lior Kupers Over a year ago

all good. happy to help :)

Collectives™ on Stack Overflow

How do I insert a specific key: value of Json into a postgres table using Node.js

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related