MCAS : Query with ActivityId

%3CLINGO-SUB%20id%3D%22lingo-sub-525048%22%20slang%3D%22en-US%22%3EMCAS%20%3A%20Query%20with%20ActivityId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525048%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'%20m%20facing%20a%20problem.%20I%20want%20to%20make%20a%20query%20base%20on%20specific%20raw%20data.%20(ActivityId)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eex%20.%20%22principalPuid%22%3A%20%221003BFFDA1B1D499%22%2C%3CBR%20%2F%3E%22RowKey%22%3A%20%22355195b04fc549379340aad7e9a01fb5___Frontdoor.Worker.razzle___Frontdoor.Worker.razzle_IN_7___0000000171799177929%22%2C%3CBR%20%2F%3E%22eventCategory%22%3A%20%22Administrative%22%2C%3CBR%20%2F%3E%22MdsQueryRowCount%22%3A%20-1%2C%3CBR%20%2F%3E%22EventName%22%3A%20%22csmEastUS2RPFEventServiceEntriesVer%22%2C%3CBR%20%2F%3E%22ActivityId%22%3A%20%2217400027-40fe-4331-be2c-71c512a6c111%22%2C%3CBR%20%2F%3E%22MD5Key%22%3A%20%225c8c611a%22%2C%3CBR%20%2F%3E%22TaskName%22%3A%20%22EventServiceEntry%22%2C%3CBR%20%2F%3E%22SourceTableName%22%3A%20%22csmEastUS2RPFEventServiceEntriesVer20v0%22%2C%3CBR%20%2F%3E%22properties%22%3A%20%22%22%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20filter%20with%20Activity%20ID%20is%26nbsp%3B17400027-40fe-4331-be2c-71c512a6c111%20does%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso..%20what%20am%20i%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EPat%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-525048%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECloud%20App%20Security%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Protection%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EThreat%20protection%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542214%22%20slang%3D%22en-US%22%3ERe%3A%20MCAS%20%3A%20Query%20with%20ActivityId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332890%22%20target%3D%22_blank%22%3E%40BlackFox%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F143984%22%20target%3D%22_blank%22%3E%40Sebastien%20Molendijk%3C%2FA%3E%3A%20Is%20this%20something%20you%20can%20help%20with%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-566339%22%20slang%3D%22en-US%22%3ERe%3A%20MCAS%20%3A%20Query%20with%20ActivityId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-566339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293935%22%20target%3D%22_blank%22%3E%40Valon_Kolica%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-568290%22%20slang%3D%22en-US%22%3ERe%3A%20MCAS%20%3A%20Query%20with%20ActivityId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-568290%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can't%20query%20MCAS%20API%20using%20the%20RAW%20data%20activity%20ID.%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20use%20the%20MCAS%20activity%20ID%2C%20so%20you%20can%20access%20the%20RAW%20data%20information.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMay%20I%20ask%20what%20you%20are%20trying%20to%20achieve%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I' m facing a problem. I want to make a query base on specific raw data. (ActivityId)

 

ex . "principalPuid": "1003BFFDA1B1D499",
"RowKey": "355195b04fc549379340aad7e9a01fb5___Frontdoor.Worker.razzle___Frontdoor.Worker.razzle_IN_7___0000000171799177929",
"eventCategory": "Administrative",
"MdsQueryRowCount": -1,
"EventName": "csmEastUS2RPFEventServiceEntriesVer",
"ActivityId": "17400027-40fe-4331-be2c-71c512a6c111",
"MD5Key": "5c8c611a",
"TaskName": "EventServiceEntry",
"SourceTableName": "csmEastUS2RPFEventServiceEntriesVer20v0",
"properties": "",

 

but filter with Activity ID is 17400027-40fe-4331-be2c-71c512a6c111 does not work.

 

so.. what am i doing wrong?

 

Thanks

Pat

3 Replies

@BlackFox 

 

@Sebastien Molendijk: Is this something you can help with? 

@Valon_Kolica 

 

?  

Hi,

 

You can't query MCAS API using the RAW data activity ID.

You have to use the MCAS activity ID, so you can access the RAW data information.

 

May I ask what you are trying to achieve ?