# API does not return double quotes in path property

**URL:** https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462
**Category:** Uncategorized
**Created:** [December 8, 2021, 3:51pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462 "2021-12-08T15:51:58Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![ben\_dy](https://avatars.discourse-cdn.com/v4/letter/b/c6cbf5/32.png) [@ben\_dy](https://community.dremio.com/u/ben_dy)
#### Post date: [December 8, 2021, 3:51pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/1 "2021-12-08T15:51:58Z")

</div>

Whenever I make an API request to the `catalog` endpoint, I receive an object that looks like this [response](https://docs.dremio.com/rest-api/catalog/get-catalog-id/#response).

That response does not include information about where double quotes (") need to be included on the path property in order to be used with services like intake\_dremio or other plugins.

From what I’ve seen, double quotes can surround anything depending on some internal Dremio protocol.

Is there a way to know where the double quotes belong around the path?

Thanks!

---

<div class="post-metadata">

### Author: ![ben\_dy](https://avatars.discourse-cdn.com/v4/letter/b/c6cbf5/32.png) [@ben\_dy](https://community.dremio.com/u/ben_dy)
#### Post date: [December 8, 2021, 4:21pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/2 "2021-12-08T16:21:46Z")

</div>

Update: It appears that there is information about escaped double quotes in [this response?](https://docs.dremio.com/rest-api/catalog/get-catalog-id/#response-1)

Looks like the information is stored in the “children” property.

Is there a reason why the escaped quotes don’t show on the response of a virtual data set?

---

<div class="post-metadata">

### Author: ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)
#### Post date: [December 8, 2021, 4:24pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/3 "2021-12-08T16:24:46Z")

</div>

The REST API doesn’t require any escaping of paths since it uses lists. SQL however does, for example:

```auto
select * from Samples."samples.dremio.com"."zip_lookup.csv"

```

Because some of the path entities contains the path seperator (`.`), you need to provide `"` around `samples.dremio.com` and `zip_lookup.csv`.

In fact, you can just put `"` around each part of the path and you should be fine.

---

<div class="post-metadata">

### Author: ![ben\_dy](https://avatars.discourse-cdn.com/v4/letter/b/c6cbf5/32.png) [@ben\_dy](https://community.dremio.com/u/ben_dy)
#### Post date: [December 15, 2021, 6:09pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/4 "2021-12-15T18:09:32Z")

</div>

Unfortunately, using double quotes around each part of the path did not solve my issue.

Is there a way to return the exact area the quotes need to go using the Dremio API?

---

<div class="post-metadata">

### Author: ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)
#### Post date: [December 15, 2021, 6:53pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/5 "2021-12-15T18:53:38Z")

</div>

How are you running SQL in Dremio exactly?

---

<div class="post-metadata">

### Author: ![ben\_dy](https://avatars.discourse-cdn.com/v4/letter/b/c6cbf5/32.png) [@ben\_dy](https://community.dremio.com/u/ben_dy)
#### Post date: [December 15, 2021, 7:34pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/6 "2021-12-15T19:34:56Z")

</div>

Basically, I use the Dremio API by sending a catalog ID with my request to gain information about a dataset.

I use the dataset path to execute SQL with plugins. Because the “quote” format isn’t included, the plugins break.

Is there a way to return the exact string format with the quotes from the Dremio API? Or should I look elsewhere (i.e. the plugin documentation) ?

---

<div class="post-metadata">

### Author: ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)
#### Post date: [December 15, 2021, 8:11pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/7 "2021-12-15T20:11:28Z")

</div>

Which plugin are you using? If its a third party library, you would need to consult with them.

---

<div class="post-metadata">

### Author: ![ben\_dy](https://avatars.discourse-cdn.com/v4/letter/b/c6cbf5/32.png) [@ben\_dy](https://community.dremio.com/u/ben_dy)
#### Post date: [August 24, 2022, 2:23pm UTC](https://community.dremio.com/t/api-does-not-return-double-quotes-in-path-property/8462/8 "2022-08-24T14:23:00Z")

</div>

Update: We had to work with the third party library to allow double quotes around all parts of the dremio path. Dremio does not have a way to return where the double quotes belong.
