x3mxray’s gists

x3mxray / models.json

Created April 15, 2025 12:10

	{
	"chat": [
	{
	"name": "awsChatBedrock",
	"models": [
	{
	"label": "anthropic.claude-3-7-sonnet-20250219-v1:0",
	"name": "anthropic.claude-3-7-sonnet-20250219-v1:0",
	"description": "(20250219-v1:0) specific version of Claude Sonnet 3.7 - hybrid reasoning model"
	},

x3mxray / products.json

Created August 14, 2024 08:43

[{"sku":"0301020100","name":"360 Black 100 ml","image":"https://arab-p-001.sitecorecontenthub.cloud/api/public/content/0301020100-main?v=f2a363e4","title":"360 Black 100 ml","description":"A fragrant aroma of incense with its enticing scent and hints of lily of the valley on a warm and woody base of woods.","categories":["Fragrance","PerfumeforHim"],"origin":null,"type":"Spray","fragrance":"Men","collection":null,"olfactory":["Oriental","Fruity"],"url":"https://ae.arabianoud.com/en/0301020100-360-black-100-ml","topNote":null,"middleNote":null,"baseNote":null},{"sku":"0301020101","name":"360 Pink 100 ml","image":"https://arab-p-001.sitecorecontenthub.cloud/api/public/content/0301020101-main?v=766e2ea8","title":"360 Pink 100 ml","description":"360 Perfume: An olfactory experience that embodies infinite elegance, with a blend of passion fruit and white sage.","categories":["Fragrance","PerfumeforHer"],"origin":null,"type":"Spray","fragrance":"Women","collection":null,"olfactory":null,"url":"https://ae.arabianoud

x3mxray / gist:6ffe47a98fc05970e9c989effd6b4ecb

Created August 14, 2024 08:34

	[
	{
	"OwnerID": "ArabianBlend",
	"DefaultPriceScheduleID": null,
	"AutoForward": false,
	"ID": "0301020507",
	"ParentID": null,
	"IsParent": false,
	"IsBundle": false,
	"Name": "Jabal Al-Cotton\nجبل قطن",

x3mxray / rfm.sql

Last active April 11, 2024 21:51

Sitecore CDP Batch Segmentation - Risky of churn customers

	SELECT g.meta_ref as guest_ref
	FROM (
	SELECT o.meta_guest_ref,
	NTILE(5) OVER (ORDER BY R DESC) as R_S,
	NTILE(5) OVER (ORDER BY F ASC) as F_S,
	NTILE(5) OVER (ORDER BY M ASC) as M_S
	FROM (
	SELECT o.meta_guest_ref,
	DATE_DIFF('day', max(date(core_ordered_at)), current_date) AS R,
	COUNT(*) AS F,

x3mxray / GTM-ECommerce-with-Siterode-CDP.json

Created October 30, 2023 17:32

	{
	"exportFormatVersion": 2,
	"exportTime": "2023-10-30 17:30:10",
	"containerVersion": {
	"path": "accounts/6203298893/containers/169827438/versions/2",
	"accountId": "6203298893",
	"containerId": "169827438",
	"containerVersionId": "2",
	"container": {
	"path": "accounts/6203298893/containers/169827438",

x3mxray / Challenge.txt

Created March 31, 2022 20:08

Password: WELCOME_TO_GIST

x3mxray / createcert.json

Last active November 23, 2022 16:04

install_iis_certificate

	{
	"Parameters": {
	"CertificateName": {
	"Type": "String",
	"Description": "The name of the certificate to be created.",
	"DefaultValue": ""
	},
	"CertPath": {
	"Type": "String",
	"Description": "The physical path on disk where certificates will be stored.",

x3mxray / Online_Retail_sitecore_commerce_habitat.csv

Created September 7, 2019 16:36

Historical Sitecore Commerce Habitat orders dataset based on a public Online Retail Dataset (~230k cartlines)

We can't make this file beautiful and searchable because it's too large.

	OrderId,ProductId,Description,Quantity,OrderDate,UnitPrice,CustomerID,Country
	536477,6001001,Smart WiFi Bundle,16,9/1/2018 12:27,200,16210,United Kingdom
	536502,6001001,Smart WiFi Bundle,2,9/1/2018 12:36,200,16552,United Kingdom
	536525,6001001,Smart WiFi Bundle,2,9/1/2018 12:54,200,14078,United Kingdom
	536528,6001001,Smart WiFi Bundle,1,9/1/2018 13:17,200,15525,United Kingdom
	536530,6001001,Smart WiFi Bundle,1,9/1/2018 13:21,200,17905,United Kingdom
	536537,6001001,Smart WiFi Bundle,2,9/1/2018 13:51,200,15922,United Kingdom
	536539,6001001,Smart WiFi Bundle,2,9/1/2018 14:03,200,15165,United Kingdom
	536562,6001001,Smart WiFi Bundle,2,9/1/2018 15:08,200,13468,United Kingdom

Sergey Baranov x3mxray