Using jsonata plugin

Need help Plugins
1

hi – i am trying to use the jsonata plugin on bubble – i think it will be what i need but i cant find any documentation of example how to use it…

when i simply put a “$” in the transform – i get this

[
{
“category_text”: “Appetizers”,
“discounts___comps_text”: “0”,
“gross_sales_text”: “9000”,
“items_refunded_text”: “0”,
“items_sold_text”: “3”,
“net_sales_text”: “9000”,
“refunds_text”: “0”,
“taxes_text”: “900”,
“total_sales_number”: 9900,
“Created Date”: “2020-08-11T01:55:38.945Z”,
“Modified Date”: “2020-08-11T01:55:40.097Z”,
“_id”: “1597110938012x459360295468400640”
},
{
“category_text”: “Bagel Boys”,
“discounts___comps_text”: “0”,
“gross_sales_text”: “58700”,
“items_refunded_text”: “0”,
“items_sold_text”: “15”,
“net_sales_text”: “58700”,
“refunds_text”: “0”,
“taxes_text”: “1670”,
“total_sales_number”: 60370,
“Created Date”: “2020-08-11T01:55:39.032Z”,
“Modified Date”: “2020-08-11T01:55:40.097Z”,
“_id”: “1597110938012x695814540597657600”
}
]

i cannot figure out how to write a transformation to customize the output

i am trying to get this…

{
  "Line": [
    {
      "DetailType": "SalesItemLineDetail", 
      "Amount": 100.0, 
      "SalesItemLineDetail": {
        "ItemRef": {
          "name": "Appetizers", 
          "value": "1"
        }
      }
    },
    {
      "DetailType": "SalesItemLineDetail", 
      "Amount": 375.0, 
      "SalesItemLineDetail": {
        "ItemRef": {
          "name": "Bagel Boys", 
          "value": "22"
        }
      }
    }
  ], 
  "CustomerRef": {
    "value": "1"
  }
}

i am thinking i need something like this:

{
  "Line": [
    {
      "DetailType": "SalesItemLineDetail", 
      "Amount": 100.0, 
      "SalesItemLineDetail": {
        "ItemRef": {
          "name": "$category_text", 
          "value": "1"
        }
      }
    }
  ], 
  "CustomerRef": {
    "value": "1"
  }
}

using $category_text as a variable – and hoping that the plugin will loop around each record of the list of things like it does when i simly use $

thank for any help someone can offer…

thanks
larry