Mitto Store Jobs - Extract internal ID from Same

Runner
#1

I have successfully imported into a database table the following JSON for the $.currency and $.priceLevel nodes. These nodes are flattened and are imported as a single row. The fields in $.priceList object are not imported.

In a separate job I have setup an import of $.priceList object (another Mitto job) however I want to be able to reference the $.priceLevel[*].internalId end point so I can create an table join on common fields.

Is this possible using Mitto store jobs?

   {
    "currency": {
      "name": "US Dollar",
      "internalId": "1",
      "externalId": null,
      "type": null,
      "__record_type": "RecordRef"
    },
    "priceLevel": {
      "name": "Base Price (MSRP)",
      "internalId": "1",
      "externalId": null,
      "type": null,
      "__record_type": "RecordRef"
    },
    "discount": null,
    "priceList": {
      "price": [
        {
          "value": 58,
          "quantity": 0,
          "__record_type": "Price"
        }
      ],
      "__record_type": "PriceList"
    },
    "__record_type": "Pricing"
  },
  {
    "currency": {
      "name": "US Dollar",
      "internalId": "1",
      "externalId": null,
      "type": null,
      "__record_type": "RecordRef"
    },
    "priceLevel": {
      "name": "Clearance",
      "internalId": "4",
      "externalId": null,
      "type": null,
      "__record_type": "RecordRef"
    },
    "discount": -50,
    "priceList": {
      "price": [
        {
          "value": 29,
          "quantity": 0,
          "__record_type": "Price"
        }
      ],
      "__record_type": "PriceList"
    },
    "__record_type": "Pricing"
  },
  {
    "currency": {
      "name": "US Dollar",
      "internalId": "1",
      "externalId": null,
      "type": null,
      "__record_type": "RecordRef"
    },
    "priceLevel": {
      "name": "Sale Price",
      "internalId": "3",
      "externalId": null,
      "type": null,
      "__record_type": "RecordRef"
    },
    "discount": -25,
    "priceList": {
      "price": [
        {
          "value": 43.5,
          "quantity": 0,
          "__record_type": "Price"
        }
      ],
      "__record_type": "PriceList"
    },
    "__record_type": "Pricing"
  }
]
#2

Yes you can add a members parameter which will add “higher level” data to the data from a sub list.

See this Mitto Store Input documentation: Mitto Store Input

Specifically the parts about Members.

Let me know if you need more guidance on this.