Check if field exists in CosmosDB JSON with SQL - nodeJS

[ForumBot]

Check if field exists in CosmosDB JSON with SQL - nodeJS

[ForumBot]

All you need to do is change your query to

```
SELECT r.id, r.authToken.instagram,r.userName FROM root r WHERE r.abc != null

```

or

```
SELECT r.id, r.authToken.instagram,r.userName FROM root r WHERE r.abc null

```

Both operators work (tested on the Data Explorer)