Parse YAML file in Google Apps Script

Question

I'm trying to parse a YAML file within Google Apps Script. I would like to use the information from a YAML file in Google Sheets.

From what I understood, the underlying library is available (Use app engine yaml parser in scripts) but I don't seem to understand how I can use this library.

Thanks

Welcome to Stack Overflow. AFAIK libraries are intended to be used with specific programming languages. The question that you linked is about scripts written in Python but Google Apps Script uses JavaScript. Keep searching / learning. — Wicket
– Wicket, Commented Mar 2, 2022 at 22:51

Yuri Khristich · Accepted Answer · 2022-03-02 23:23:16Z

3

I suppose it can depend on how complicated is your yaml. For simply cases you can use this lib https://code.google.com/archive/p/javascript-yaml-parser/downloads

Just download and unpack the latest .gz file and copy contents of the file yaml.js into your project:

Then you can convert your yaml string into a json object this way:

// your YAML sting

var string =
`foo: bar
stuff:
  foo: bar
  bar: foo
arr:
  - aaa
  - bbb
  - ccc
`

// JSON object

var obj = YAML.eval(string);

console.log(JSON.stringify(obj))

Output:

{
  "foo": "bar",
  "stuff": {
    "foo": "bar",
    "bar": "foo"
  },
  "arr": ["aaa", "bbb", "ccc"]
}

edited Mar 2, 2022 at 23:23

answered Mar 2, 2022 at 23:05

Yuri Khristich

14.6k3 gold badges11 silver badges25 bronze badges

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

2 Comments

Yuri Khristich Over a year ago

The similar (but not quite) question is here: stackoverflow.com/questions/67898452/…

Cláudio Silva Over a year ago

Thanks! This was the route that I went with and it worked out perfectly.

Collectives™ on Stack Overflow

Parse YAML file in Google Apps Script

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related