modern-farmer-99434
thankful-potato-8143
04/21/2022, 6:17 PMnumerous-kitchen-49366
04/21/2022, 8:19 PMcuddly-architect-37695
04/22/2022, 2:47 PMred-caravan-3691
04/27/2022, 5:36 PMorganization!=<http://mycompany.com|mycompany.com>
thankful-potato-8143
04/28/2022, 9:10 PMripe-tailor-83334
04/29/2022, 7:38 PMthankful-potato-8143
05/03/2022, 2:17 PMminiature-teacher-65329
05/09/2022, 8:59 PMgreat-daybreak-70417
05/11/2022, 9:32 AM[
{
"account_name": "Account-A",
"asset_type": "Type1",
"Name": "foo1",
"Category": "bar",
"SubCategory": "1",
"tags": "{\"value\": \"ateam\", \"key\": \"team\"}"
},
{
"account_name": "Account-A",
"asset_type": "Type1",
"Name": "foo3",
"Category": "bar2",
"SubCategory": "1",
"tags": "{\"value\": \"bteam\", \"key\": \"team\"}"
},
{
"account_name": "Account-A",
"asset_type": "Type1",
"Name": "foo2",
"Category": "bar1",
"SubCategory": "1",
"tags": "{\"value\": \"bteam\", \"key\": \"team\"}"
},
{
"account_name": "Account-B",
"asset_type": "Type3",
"Name": "foo3",
"Category": "bar",
"SubCategory": "3",
"tags": ""
}
]
Output object:
[
{
"account_name": "Account-A",
"asset_type": "Type1",
"Name": "foo1",
"Category": "bar",
"SubCategory": "1",
"tags": "{\"value\": \"ateam\", \"key\": \"team\"}",
"team": "ateam"
},
{
"account_name": "Account-A",
"asset_type": "Type1",
"Name": "foo3",
"Category": "bar2",
"SubCategory": "1",
"tags": "{\"value\": \"bteam\", \"key\": \"team\"}"
"team": "bteam"
},
{
"account_name": "Account-A",
"asset_type": "Type1",
"Name": "foo2",
"Category": "bar1",
"SubCategory": "1",
"tags": "{\"value\": \"bteam\", \"key\": \"team\"}",
"team": "bteam"
},
{
"account_name": "Account-B",
"asset_type": "Type3",
"Name": "foo3",
"Category": "bar",
"SubCategory": "3",
"tags": "",
"team": "unknown"
}
]
Thanks 🙏great-daybreak-70417
05/13/2022, 12:35 PMgreen-architect-4647
05/13/2022, 7:51 PM{
"events": [...],
"entities": [...]
}
green-architect-4647
05/14/2022, 1:46 PMthankful-potato-8143
05/16/2022, 3:49 PMgreat-daybreak-70417
05/19/2022, 3:44 PMWHERE(compile_assets.array, "asset_type", LOOP.value)
in a single event transform?
Where the loop value is a resource with a dictionary of 'asset_types' that i want to remove from the 'assets.array'.
The WHERE
works, but as the list of types im not interested in is smaller, it's easier to maintain the resource for those i don't want to keep.
Thanksearly-vegetable-9315
05/20/2022, 2:03 PMmysterious-winter-58499
05/25/2022, 1:03 PMgreen-architect-4647
05/25/2022, 3:35 PMthankful-potato-8143
05/25/2022, 10:09 PMred-caravan-3691
05/25/2022, 10:52 PMgray-wall-69994
05/26/2022, 6:41 PMstraight-judge-35557
05/27/2022, 7:46 AMgreen-architect-4647
05/27/2022, 3:15 PMoptions
with some find/replace to unescape the `"`s and then pasting into the template UI.miniature-crayon-82650
06/02/2022, 2:31 PMancient-flower-50991
06/02/2022, 5:59 PMred-caravan-3691
06/03/2022, 10:10 PMValue at <X> is not an array or does not exist
As the return output is a huge list which is sub-divided into Arrays containing JSON, kinda like:
{
"get_a_list_of_users_in_sumo_logic":
{
"body":
{
"data":
[
{
"firstName":"X",
"lastName":"X",
"email":"X",
"roleIds":
[
],
"createdAt":"X",
"createdBy":"X",
"modifiedAt":"X",
"modifiedBy":"X",
"id":"X",
"isActive":true,
"isLocked":false,
"isMfaEnabled":false,
"lastLoginTimestamp":"X"
},
Followed by the next user etc..
Im not sure if I am using Explode correctly herered-daybreak-70524
06/04/2022, 2:03 PM<https://www.uuidgenerator.net/api>
millions-market-59432
06/10/2022, 4:47 PMthankful-potato-8143
06/13/2022, 4:23 PMred-caravan-3691
06/14/2022, 3:31 PM