Generic REST API Connector allows to configure attribute mappings using JSONPath language.

Following table shows supported and not supported JSONPath syntaxes. Because there are so many possible JSONPath expressions, this table doesn't contain everything. So something outside of supported ones probably also works.

Main unsupported thing is that if JSONPath returns an array of JSON objects, that is not supported.

JSONPath mappings were tested agains this example json:

{
  "id": "u-123",
  "user": {
    "name": "Ada Lovelace",
    "email": "ada@example.com",
    "first-name": "Ada",
    "meta": {
      "active": true,
      "score": 42,
      "nullField": null
    }
  },
  "store": {
    "book": "abc",
    "bike": "xyz",
    "nested": {
      "price": 9.99,
      "currency": "EUR"
    }
  },
  "groups": ["Admin", "HR"],
  "groupObjects": [
    { "name": "Admin", "id": 1, "enabled": true },
    { "name": "HR", "id": 2, "enabled": false }
  ],
  "child": {
    "id": "child-1",
    "child": {
      "id": "child-2"
    }
  },
  "storeList": [
    { "id": "s1", "name": "Shop 1", "price": 10 },
    { "id": "s2", "name": "Shop 2", "price": 20 }
  ],
  "emptyArray": [],
  "emptyObject": {},
  "weirdKeys": {
    "a.b": "dot-key",
    "space key": "space-key",
    "brackets[key]": "bracket-key"
  }
}

Supported and not supported JSONPath syntaxes

Subquery mappings

Subquery mappings first part is subquery itself, then dot and then actual JSONPath same way than in supported JSONPath syntaxes table.

Example for fetching users group memberships from Google

Subquery: groups?userKey={id}

In subquery {id} is dynamic variable, which in this case points to main query resultset id attribute. JSONPath is not supported on subqueries.

Mapping for that subquery, to fetch id's of groups which one user belongs: 
groups?userKey={id}.groups[*].id where actual JSONPath is this part on the end: groups[*].id

Example of Google groups API json. With subquery and mapping we can pick id's of groups from this resultset.
 {
 "kind": "directory#groups",
 "etag": "\"p7cdf8ab12e9\"",
 "groups": [
   {
     "kind": "directory#group",
     "id": "01abcde123456789",
     "etag": "\"abc123etag\"",
     "email": "engineering@efectebaselinedev.onmicrosoft.com",
     "name": "Engineering Team",
     "description": "Main engineering group",
     "directMembersCount": "15",
     "adminCreated": true,
     "aliases": [
       "eng@efectebaselinedev.onmicrosoft.com"
     ],
     "nonEditableAliases": [
       "engineering@group.calendar.google.com"
     ]
   },
   {
     "kind": "directory#group",
     "id": "02xyz987654321",
     "etag": "\"xyz456etag\"",
     "email": "support@efectebaselinedev.onmicrosoft.com",
     "name": "Support",
     "description": "Customer support group",
     "directMembersCount": "8",
     "adminCreated": true
   }
 ],
 "nextPageToken": "CgYIARAA"
}