Skip to main content
Version: 8.4.12.1

Schema: ToolCompositeExecution (ID: 3480)

METADATA

AttributeValue
Topic3480-mlink-custom
MLink TokenClientTrading
SRSE ProductSRTrade

Note: The symbol = next to a field number indicates that it is a primary key.

BODY

#FieldTypeComment
10=fillNumberlongSpiderRock execution number (globally unique over trailing 10 days)
100tradeDateDateKeytrade date
103accntstring(16)SpiderRock Accnt Code
106clientFirmstring(16)SpiderRock ClientFirm Code
109secKeyOptionKeySecurity Key [can be partially filled in (look at secType)]
112secTypeenum : SpdrKeyTypeSecurity Type [Stock, Future, Option]
115sideenum : BuySellorder / execution side
118versionbyterecord version number; starts at zero and goes up every time an execution record is re-published (eg, bust, +1m marks, +10m marks, etc)
121parentNumberlongSpiderRock parent number
124baseParentNumberlongSpiderRock base parent number
127spdrSourceenum : SpdrSourceSpiderRock parent order source code [broker pkey]
130groupingCodelongSpiderRock parent broker number [broker pkey]
133riskGroupIdlongriskGroupId (parent order group ID) for this execution report
136altOrderIdstring(24)alternate order ID (usually clOrdId from client)
139srcRoutingCodetext1inbound FIX routing code, if any
142userNamestring(24)SpiderRock user name associated with the parent order
145serverstring(20)SpiderRock execution engine that handled the parent order
148tickerTickerKeySpiderRock underlier ticker key [synthetic for futures]
151sectorstring(16)user supplied sector code (from SymbolControl record)
154clientTagstext1
157indNumintind code (00)
160subNumintsub code (0000)
163grpNumintgrp code (000000)
166nbrNumintnbr code (00000000)
169expCodeenum : ExpCodeexpiration tenor code
172skewCodeenum : SkewCodestrike skew code (@ parent order arrival)
175widthCodeenum : WidthCodemarket width code
178priceFormatenum : PriceFormatSpiderRock price display format code
181uPriceFormatenum : PriceFormatSpiderRock underlier price display code
184yearsfloatyears to expiration (@ parent order arrival)
187underlierTypeenum : UnderlierTypeunderlier type (affects $greek calcs)
190minTickSizefloat$NLV value of a single tick change in display premium (pointValue = tickValue / tickSize)
193pointValuefloat$NLV value of a point
196pointCurrencyenum : Currency
199underliersPerCnintunderliers per contract (futures and options)
202parentShapeenum : SpdrOrderShapeparent order shape [Single, MLeg, etc]
205parentLimitTypeenum : SpdrLimitTypeparent order limit type [Vol, VolX, PrcDe, PrcDeX, etc]
208parentLimitClassenum : SpdrLimitClassparent order limit class (makeLimitClass if fill was from making; takeLimitClass if fill was from taking)
211parentOrderHandlingenum : ParentOrderHandlingbase parent order algo [take style algo]
214parentBalanceHandlingenum : ParentBalanceHandlingbase parent order balance handling [make style algo]
217parentOrderSizeintparent order size
220parentDttmDateTimeDate/time of parent order arrival
223parentUMarkdoubleunderlier mid mark @ parent order arrival (options only)
226parentBiddoublemarket bid @ parent order arrival
229parentAskdoublemarket ask @ parent order arrival
232parentFairPrcfloatSpiderRock fair price @ parent order arrival
235parentFairWidthfloatSpiderRock fair width @ parent order arrival
238parentLimitPrcdoubleparent order limit price @ parent order arrival
241parentLimitRefUPrcdoublelimit reference underlier price @ parent order arrival (options only)
244parentSSaleFlagenum : ShortSaleFlagparent order short sale flag (can be Auto)
247parentPositionTypeenum : PositionTypeparent order position type (can be Auto)
250parentStrategystring(36)parent strategy [usually client supplied]
253parentAutoHedgeenum : AutoHedgeSpiderRock auto-hedge algorithm (if any)
256childDttmDateTimechild order send date/time (if any)
259childClOrdIdstring(24)child order clOrdId resulting in fill (if any)
262childRoutingCodetext1SpiderRock child order routing code (if any)
265childSizeintchild order size
268childPricedoublechild order price
271childExchstring(6)child order exchange code (SpiderRock)
600childExDeststring(16)child order exchange code (downstream)
277childUPrcdoubleunderlier market price @ child order send time
280childBiddoublemarket bid @ child order send time
283childAskdoublemarket ask @ child order send time
286childFairPrcfloatSpiderRock fair price @ child order send time
289childFairWidthfloatSpiderRock fair width @ child order send time
292childVolfloatchild order volatilty (options only)
295childProbfloatchild order probability (T+x)
298childLimitPrcdoubleparent order limit price @ child order send time
301childLimitRefUPrcdoublelimit reference underlier price @ child order send time (options only)
304childAlgoHandlerenum : ChildHandleralgo that generated the child order responsible for this fill
307childOrderHandlingstring(24)algo handler detail string
310childCreateReasonenum : ChildCreateReasonchild order create code
313childCancelReasonenum : ChildCancelReasonchild order cancel code (if any)
316childMktStanceenum : MktStancechild order was expected to be marketable @ child send time
319childCxlAttemptedenum : YesNocancel attempt was made on the child order prior to receiving this fill
322childSSaleFlagenum : ShortSaleFlagchild order short sale flag
325childPositionTypeenum : PositionTypechild order position type
328childFirmTypeenum : FirmTypechld order firm type [Customer, ProCust, Firm, MM, etc]
331childCapacityenum : OrderCapacitychild order capacity
334fillExchstring(12)ExDest code from child order execution report (lastMkt)
337fillPricedoublefill price
340fillDttmDateTimeDate/time of fill arrival
343fillSizeintfill quantity
346fillPointValueintfill size x pointValue
349fillVolfloatfill volatilty (options only)
352fillProbfloatfill order probability (T+x)
355fillLimitPrcdoubleparent order limit price @ fill arrival time
358fillLimitRefUPrcdoublelimit reference underlier price @ fill arrival time (options only)
361fillUPrcdoublefill underlier mid-market
364fillBetafloatSpiderRock estimate of beta to SPX
367fillTvfloattheo vol (user supplied)
370fillTpfloattheo price
373fillBiddoubleoption market bid @ fill arrival
376fillAskdoubleoption market ask @ fill arrival
379fillFairPrcfloatSpiderRock fair price @ fill arrival
382fillFairWidthfloatSpiderRock fair width @ fill arrival
385fillBrkrRatefloatbilling brokerage rate (tier 1)
388fillRoutingRatefloatbilling routing rate (tier 1)
391fillOrigExecIDstring(20)original execution ID string (child order)
394fillLastExecIDstring(20)most recent execution ID (same as origExecID unless CANCEL/CORRECTION has been processed)
397fillExecStatusenum : ExecStatusSpiderRock execution status (Fill,Bust,Correct,Reject,SysRej)
400fillRemoteTextstring(64)text comment from endpoint (if any)
403fillTransactDttmDateTimetransaction date/time as reported by exchange or down stream broker
406fillLiquidityTagstring(2)SpiderRock normalized exch liquidity tag
409fillExchFeefloatSpiderRock exchange fee estimate
412fillDefloat
415fillGafloat
418fillVefloat
421execRoleenum : ExecRoleSpiderRock relationship to this execution record (Direct, Drop, etc)
599execBrkrCodestring(16)exec broker acronym (usually an MPID)
427execBrkrAccntstring(16)account at executing broker (if any)
430execBrkrClFirmstring(16)client/firm at executing broker (if any)
433execBrkrUserNamestring(16)user executing broker (if any)
436clearingFlipTypeenum : FlipTypetype of clearing corp delivery
439clearingFlipFirmstring(6)deliverTo clearing member (eg. OCC#, NSCC#, MPID, or InstitutionID)
442clearingFlipAccntstring(10)deliverTo client account (eg. OCC AID# or a DVP FBO code)
593clearingAgentstring(10)deliverTo agent (eg. DVP Agent Bank ID)
594clearingTaxIDstring(10)deliverTo taxID (eg. DVP TaxID)
445billingSecTypeenum : BillingSecTypeSpiderRock billing security type
448billingCategoryenum : BillingCategorySpiderRock billing category
451priAggGroupstring(16)primary aggregation group
454secAggGroupstring(16)secondary aggregation group
457trdDeltafloattrade delta
460trdDDeltafloattrade $delta
463trdGammafloattrade gamma
466trdDGammafloattrade dollar gamma
469trdVegafloattrade vega
472trdWtVegafloattrade wtVega: (vega * vol / sqrt(max(0.1, years * 4))
478trdThetafloattrade theta
481trdBetafloattrade beta
484trdDBetafloattrade $beta
487trdNotionalValuefloatcn * pointValue * uPrc
490trdMarketValuefloatcn * pointValue * fillPrice
595marginUDnVDnfloatAggregate RiskSlide: uPrc dn, vol dn
596marginUDnVUpfloatAggregate RiskSlide: uPrc dn, vol up
597marginUUpVDnfloatAggregate RiskSlide: uPrc up, vol dn
598marginUUpVUpfloatAggregate RiskSlide: uPrc up, vol up
517trdFairEdgefloatSR trade edge (fill price to SR fair price)
520trdFairEdgeUnitfloatSR trade edge normalized to $100 underlier
523trdTheoEdgefloattheo edge (user supplied theo vol/prc to SpiderRock surface price) (if any)
526trdTheoEdgeUnitfloattheo edge normalized to $100 underlier
529clArrivePnLfloatarrival PnL (client arrival mark to fill mark) [from clArriveMark on parent order if any]
532arrivePnLfloatarrival PnL (parent arrival mark to fill mark)
535arriveDnPnLfloatarrival Dn PnL (arrivalPnL - uDriftArrivalPnL)
538uDriftArrivePnLfloatunderlier delta drift PnL (arrival uMark to fill uMark)
541childLimitSlipfloatFill Slippage (ChildLimitPrice to FillPrice)
544halfWidthPnLfloatestimated half-width PnL
547dayDnPnLfloatdelta neutral PnL (to EOD)
550dayM1PnLfloatdelta neutral PnL (Fill + 1M)
553dayM10PnLfloatdelta neutral PnL (Fill + 10M)
556uDriftDayPnLfloatunderlier delta drift PnL (to EOD)
559uDriftM1PnLfloatunderlier delta drift PnL (Fill + 1M)
562uDriftM10PnLfloatunderlier delta drift PnL (Fill + 10M)
565dayPnLfloatactual PnL to EOD (fillMark to liveMark)
568m1MarkdoubleT+1min
571m1UPrcdoubleT+1min
574m10MarkdoubleT+10min
577m10UPrcdoubleT+10min
580liveMarkdoubleLive @ Record Query
583liveUPrcdoubleLive @ Record Query
586trdMarkErrorstring(8)trade mark error code
589dayMarkErrorstring(8)day mark error code
592timestampDateTimeSR system timestamp

Get Schema API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'ToolCompositeExecution'

# Request Parameters for Get Schema Of The MsgType
params = {
#Required Parameters
"apiKey": API_KEY,
"cmd": 'getschema',
"msgType": MSG_TYPE,
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Msg API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'ToolCompositeExecution'

# Replace with your pkey value for getting the specific message desired
PKEY = 'ReplaceThisValueForTheQueryToWork'

# Replace with your desired view. A "|" separated list of views can be provided
# If no view is provided, all views will be returned.
VIEW = 'tradeDate|accnt|clientFirm|secKey|secType|side|version|parentNumber|baseParentNumber|spdrSource|groupingCode|riskGroupId|altOrderId|srcRoutingCode|userName|server|ticker|sector|clientTags|indNum|subNum|grpNum|nbrNum|expCode|skewCode|widthCode|priceFormat|uPriceFormat|years|underlierType|minTickSize|pointValue|pointCurrency|underliersPerCn|parentShape|parentLimitType|parentLimitClass|parentOrderHandling|parentBalanceHandling|parentOrderSize|parentDttm|parentUMark|parentBid|parentAsk|parentFairPrc|parentFairWidth|parentLimitPrc|parentLimitRefUPrc|parentSSaleFlag|parentPositionType|parentStrategy|parentAutoHedge|childDttm|childClOrdId|childRoutingCode|childSize|childPrice|childExch|childExDest|childUPrc|childBid|childAsk|childFairPrc|childFairWidth|childVol|childProb|childLimitPrc|childLimitRefUPrc|childAlgoHandler|childOrderHandling|childCreateReason|childCancelReason|childMktStance|childCxlAttempted|childSSaleFlag|childPositionType|childFirmType|childCapacity|fillExch|fillPrice|fillDttm|fillSize|fillPointValue|fillVol|fillProb|fillLimitPrc|fillLimitRefUPrc|fillUPrc|fillBeta|fillTv|fillTp|fillBid|fillAsk|fillFairPrc|fillFairWidth|fillBrkrRate|fillRoutingRate|fillOrigExecID|fillLastExecID|fillExecStatus|fillRemoteText|fillTransactDttm|fillLiquidityTag|fillExchFee|fillDe|fillGa|fillVe|execRole|execBrkrCode|execBrkrAccnt|execBrkrClFirm|execBrkrUserName|clearingFlipType|clearingFlipFirm|clearingFlipAccnt|clearingAgent|clearingTaxID|billingSecType|billingCategory|priAggGroup|secAggGroup|trdDelta|trdDDelta|trdGamma|trdDGamma|trdVega|trdWtVega|trdTheta|trdBeta|trdDBeta|trdNotionalValue|trdMarketValue|marginUDnVDn|marginUDnVUp|marginUUpVDn|marginUUpVUp|trdFairEdge|trdFairEdgeUnit|trdTheoEdge|trdTheoEdgeUnit|clArrivePnL|arrivePnL|arriveDnPnL|uDriftArrivePnL|childLimitSlip|halfWidthPnL|dayDnPnL|dayM1PnL|dayM10PnL|uDriftDayPnL|uDriftM1PnL|uDriftM10PnL|dayPnL|m1Mark|m1UPrc|m10Mark|m10UPrc|liveMark|liveUPrc|trdMarkError|dayMarkError|timestamp'

# Replace with your desired where clause.
# a string in the form "field1:eq:valuse" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Request Parameters for getmsg Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getmsg',
"pkey": PKEY,
"msgType": MSG_TYPE,
# Optional Parameters
"view": VIEW,
"where": WHERE
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Msgs API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'ToolCompositeExecution'

# Replace with your desired view. A "|" separated list of views can be provided
# If no view is provided, all views will be returned
VIEW = 'tradeDate|accnt|clientFirm|secKey|secType|side|version|parentNumber|baseParentNumber|spdrSource|groupingCode|riskGroupId|altOrderId|srcRoutingCode|userName|server|ticker|sector|clientTags|indNum|subNum|grpNum|nbrNum|expCode|skewCode|widthCode|priceFormat|uPriceFormat|years|underlierType|minTickSize|pointValue|pointCurrency|underliersPerCn|parentShape|parentLimitType|parentLimitClass|parentOrderHandling|parentBalanceHandling|parentOrderSize|parentDttm|parentUMark|parentBid|parentAsk|parentFairPrc|parentFairWidth|parentLimitPrc|parentLimitRefUPrc|parentSSaleFlag|parentPositionType|parentStrategy|parentAutoHedge|childDttm|childClOrdId|childRoutingCode|childSize|childPrice|childExch|childExDest|childUPrc|childBid|childAsk|childFairPrc|childFairWidth|childVol|childProb|childLimitPrc|childLimitRefUPrc|childAlgoHandler|childOrderHandling|childCreateReason|childCancelReason|childMktStance|childCxlAttempted|childSSaleFlag|childPositionType|childFirmType|childCapacity|fillExch|fillPrice|fillDttm|fillSize|fillPointValue|fillVol|fillProb|fillLimitPrc|fillLimitRefUPrc|fillUPrc|fillBeta|fillTv|fillTp|fillBid|fillAsk|fillFairPrc|fillFairWidth|fillBrkrRate|fillRoutingRate|fillOrigExecID|fillLastExecID|fillExecStatus|fillRemoteText|fillTransactDttm|fillLiquidityTag|fillExchFee|fillDe|fillGa|fillVe|execRole|execBrkrCode|execBrkrAccnt|execBrkrClFirm|execBrkrUserName|clearingFlipType|clearingFlipFirm|clearingFlipAccnt|clearingAgent|clearingTaxID|billingSecType|billingCategory|priAggGroup|secAggGroup|trdDelta|trdDDelta|trdGamma|trdDGamma|trdVega|trdWtVega|trdTheta|trdBeta|trdDBeta|trdNotionalValue|trdMarketValue|marginUDnVDn|marginUDnVUp|marginUUpVDn|marginUUpVUp|trdFairEdge|trdFairEdgeUnit|trdTheoEdge|trdTheoEdgeUnit|clArrivePnL|arrivePnL|arriveDnPnL|uDriftArrivePnL|childLimitSlip|halfWidthPnL|dayDnPnL|dayM1PnL|dayM10PnL|uDriftDayPnL|uDriftM1PnL|uDriftM10PnL|dayPnL|m1Mark|m1UPrc|m10Mark|m10UPrc|liveMark|liveUPrc|trdMarkError|dayMarkError|timestamp'

# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Replace with your desired limit of how many messages you receive. The default limit is 500
LIMIT = 500

# Order clause eg. "(field1:DESC | field1:ASC | field2:DESC:ABS | field2:ASC:ABS" (default is unordered; default is faster)
ORDER = 'tradeDate:ASC'

# Request Parameters for getmsgs Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getmsgs',
"msgType": MSG_TYPE,
# Optional Parameters
"view": VIEW,
"where": WHERE,
"limit": LIMIT,
"order": ORDER
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Aggregate API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'ToolCompositeExecution'

# Replace with fields you want to see aggregate values for. A "|" separated list of measures should be provided
MEASURE = 'tradeDate|accnt|clientFirm|secKey|secType|side|version|parentNumber|baseParentNumber|spdrSource|groupingCode|riskGroupId|altOrderId|srcRoutingCode|userName|server|ticker|sector|clientTags|indNum|subNum|grpNum|nbrNum|expCode|skewCode|widthCode|priceFormat|uPriceFormat|years|underlierType|minTickSize|pointValue|pointCurrency|underliersPerCn|parentShape|parentLimitType|parentLimitClass|parentOrderHandling|parentBalanceHandling|parentOrderSize|parentDttm|parentUMark|parentBid|parentAsk|parentFairPrc|parentFairWidth|parentLimitPrc|parentLimitRefUPrc|parentSSaleFlag|parentPositionType|parentStrategy|parentAutoHedge|childDttm|childClOrdId|childRoutingCode|childSize|childPrice|childExch|childExDest|childUPrc|childBid|childAsk|childFairPrc|childFairWidth|childVol|childProb|childLimitPrc|childLimitRefUPrc|childAlgoHandler|childOrderHandling|childCreateReason|childCancelReason|childMktStance|childCxlAttempted|childSSaleFlag|childPositionType|childFirmType|childCapacity|fillExch|fillPrice|fillDttm|fillSize|fillPointValue|fillVol|fillProb|fillLimitPrc|fillLimitRefUPrc|fillUPrc|fillBeta|fillTv|fillTp|fillBid|fillAsk|fillFairPrc|fillFairWidth|fillBrkrRate|fillRoutingRate|fillOrigExecID|fillLastExecID|fillExecStatus|fillRemoteText|fillTransactDttm|fillLiquidityTag|fillExchFee|fillDe|fillGa|fillVe|execRole|execBrkrCode|execBrkrAccnt|execBrkrClFirm|execBrkrUserName|clearingFlipType|clearingFlipFirm|clearingFlipAccnt|clearingAgent|clearingTaxID|billingSecType|billingCategory|priAggGroup|secAggGroup|trdDelta|trdDDelta|trdGamma|trdDGamma|trdVega|trdWtVega|trdTheta|trdBeta|trdDBeta|trdNotionalValue|trdMarketValue|marginUDnVDn|marginUDnVUp|marginUUpVDn|marginUUpVUp|trdFairEdge|trdFairEdgeUnit|trdTheoEdge|trdTheoEdgeUnit|clArrivePnL|arrivePnL|arriveDnPnL|uDriftArrivePnL|childLimitSlip|halfWidthPnL|dayDnPnL|dayM1PnL|dayM10PnL|uDriftDayPnL|uDriftM1PnL|uDriftM10PnL|dayPnL|m1Mark|m1UPrc|m10Mark|m10UPrc|liveMark|liveUPrc|trdMarkError|dayMarkError|timestamp'

# Replace with fields you want to see aggregated. A "|" separated list of fields should be provided
GROUP = 'secType|side|spdrSource|expCode|skewCode|widthCode|priceFormat|uPriceFormat|underlierType|pointCurrency|parentShape|parentLimitType|parentLimitClass|parentOrderHandling|parentBalanceHandling|parentSSaleFlag|parentPositionType|parentAutoHedge|childAlgoHandler|childCreateReason|childCancelReason|childMktStance|childCxlAttempted|childSSaleFlag|childPositionType|childFirmType|childCapacity|fillExecStatus|execRole|clearingFlipType|billingSecType|billingCategory'

# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Request Parameters for getaggregate Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getaggregate',
"msgType": MSG_TYPE,
"measure": MEASURE,
"group": GROUP,
# Optional Parameters
"where": WHERE,
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Count API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'ToolCompositeExecution'

# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Request Parameters for getCount Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getcount',
"msgType": MSG_TYPE,
# Optional Parameters
"where": WHERE,
}

response = requests.get(MLINK_PROD_URL, params=params)