How to retrieve transaction details from data block in the blockchain via Azure Blockchain Workbench

%3CLINGO-SUB%20id%3D%22lingo-sub-375925%22%20slang%3D%22en-US%22%3EHow%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workbench%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-375925%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20setup%20a%20use%20case%20of%20supply%20chain%20blockchain%20sample%20application%20in%20Azure%20Blockchain%20Workbench.%26nbsp%3B%20However%2C%20if%20I%20want%20to%20demonstrate%20the%20transaction%20of%20hash%20chain%20for%20proof%20of%20concept%2C%20how%20can%20I%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workbench%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EWilson%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389715%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F302317%22%20target%3D%22_blank%22%3E%40wilsonclwong%3C%2FA%3E%26nbsp%3BIn%20the%20Activity%20view%2C%20click%20on%20the%20transaction%20you%20care%20about.%20In%20the%20pane%2C%20you%20will%20see%20the%20Transaction%20hash.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486957%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486957%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26108%22%20target%3D%22_blank%22%3E%40Zeyad%20Rajabi%3C%2FA%3E-%20it%20is%20easy%20to%20see%20transaction%20details%20from%20workbench%20app%2C%20as%20those%20details%20are%20retrieved%20from%20SQL%20instance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%3A%20how%20to%20retrieve%20transaction(s)%20details%20directly%20from%20ethereum%20on%20Azure%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eps%3A%20could%20I%20sent%20request%20to%20rpc_endpoint%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20troubled%20as%20provisioned%20ethereum%20VMs%20has%20private%20ip(s)%20only.%3C%2FP%3E%3CP%3ELike%20the%20one%3A%20%3CA%20href%3D%22http%3A%2F%2F10.0.xxx.xxx%3A8540%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2F10.0.xxx.xxx%3A8540%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486967%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F198143%22%20target%3D%22_blank%22%3E%40Elkhan%20Yusubov%3C%2FA%3E%26nbsp%3BWe%20close%20down%20the%20IP%20for%20security%2C%20but%20you%20can%20manually%20open%20it%20up%20again.%20Note%2C%20if%20you%20do%20so%20you%20are%20exposing%20your%20endpoint%20to%20the%20internet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487055%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487055%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26108%22%20target%3D%22_blank%22%3E%40Zeyad%20Rajabi%3C%2FA%3EThanks%20for%20quick%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%2C%20I%20am%20experiencing%20issues%20on%20workbench%20app%2C%20after%20Ethereum%20VMs%20(2)%20are%20restarted.%3C%2FP%3E%3CP%3EError%20on%20workbench%20app%20says%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%22This%20may%20take%20some%20time.%20Your%20administrator%20can%20use%20RequestId%2011df8762-9b99-4eea-a2d7-abb6c67b482a%20to%20look%20up%20details%20in%20Application%20Insights.%3C%2FSPAN%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fworkbenchtroubleshooting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ELearn%20more.%3C%2FA%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20resolve%20above%20error%20issues%3F%3C%2FP%3E%3CP%3Eps%3A%20I%20see%20errors%20in%20application%20insight%20(attached%20screen-shot)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487159%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487159%22%20slang%3D%22en-US%22%3EWhat%20is%20the%20recommended%20way%20to%20do%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487472%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487472%22%20slang%3D%22en-US%22%3EHi%20Elkan%2C%20to%20answer%20your%20question%20around%20exposing%20that%20RPC%20endpoint%20publicly%2C%20I'm%20directing%20you%20to%20Azure%20Networking%20documentation%20for%20best%20and%20most%20up%20to%20date%20guidance%20-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-network%2Fvirtual-network-service-endpoints-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-network%2Fvirtual-network-service-endpoints-overview%3C%2FA%3E%20Hope%20this%20helps!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487575%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F198143%22%20target%3D%22_blank%22%3E%40Elkhan%20Yusubov%3C%2FA%3E%26nbsp%3BThanks%20for%20sharing%20details.%20It%20looks%20like%20some%20of%20the%20Workbench%20services%20may%20not%20be%20working%20properly.%20Can%20you%20try%20restarting%20the%20workbench%20VM%3F%20(not%20the%20blockchain%20network%20VMs)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1016097%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1016097%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26108%22%20target%3D%22_blank%22%3E%40Zeyad%20Rajabi%3C%2FA%3E%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F79934%22%20target%3D%22_blank%22%3E%40Brenda%20Lee%3C%2FA%3E%26nbsp%3B%20How%20can%20I%20access%20the%20transaction%20data%20programatically(via%20APIs)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356414%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356414%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F302317%22%20target%3D%22_blank%22%3E%40wilsonclwong%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20configuring%20Azure%20blockchain%20workbench%20.SQL%20database%20will%20also%20be%20created%20in%20resources.%20You%20may%20login%20to%20sql%20database%20with%20credentials%20you%20have%20provided%20at%20time%20of%20configuring%20Azure%20workbench%20and%20can%20see%20transaction%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20capture%20those%20transaction%20to%20trigger%20any%20event%20you%20may%20also%20use%20logic%20app%20connector.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3EAsif%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356419%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20retrieve%20transaction%20details%20from%20data%20block%20in%20the%20blockchain%20via%20Azure%20Blockchain%20Workb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356419%22%20slang%3D%22en-US%22%3EYes%20via%20apis%20and%20ethereum%20connector%20in%20logic%20apps%20to%20capture%20event%20data%20.%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have setup a use case of supply chain blockchain sample application in Azure Blockchain Workbench.  However, if I want to demonstrate the transaction of hash chain for proof of concept, how can I retrieve transaction details from data block in the blockchain via Azure Blockchain Workbench?

 

Please advice.

 

Regards,

Wilson

10 Replies

@wilsonclwong In the Activity view, click on the transaction you care about. In the pane, you will see the Transaction hash. 

@Zeyad Rajabi- it is easy to see transaction details from workbench app, as those details are retrieved from SQL instance.

 

Question: how to retrieve transaction(s) details directly from ethereum on Azure?

 

ps: could I sent request to rpc_endpoint? 

I am troubled as provisioned ethereum VMs has private ip(s) only.

Like the one: http://10.0.xxx.xxx:8540

@Elkhan Yusubov We close down the IP for security, but you can manually open it up again. Note, if you do so you are exposing your endpoint to the internet. 

@Zeyad RajabiThanks for quick response.

 

Currently, I am experiencing issues on workbench app, after Ethereum VMs (2) are restarted.

Error on workbench app says:

"This may take some time. Your administrator can use RequestId 11df8762-9b99-4eea-a2d7-abb6c67b482a to look up details in Application Insights. Learn more."

 

How to resolve above error issues?

ps: I see errors in application insight (attached screen-shot):

 

Hi Elkan, to answer your question around exposing that RPC endpoint publicly, I'm directing you to Azure Networking documentation for best and most up to date guidance - https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-service-endpoints-overview Hope this helps!

@Elkhan Yusubov Thanks for sharing details. It looks like some of the Workbench services may not be working properly. Can you try restarting the workbench VM? (not the blockchain network VMs)

@Zeyad Rajabi@Brenda Lee  How can I access the transaction data programatically(via APIs)?

Hi @wilsonclwong ,

 

After configuring Azure blockchain workbench .SQL database will also be created in resources. You may login to sql database with credentials you have provided at time of configuring Azure workbench and can see transaction details.

 

To capture those transaction to trigger any event you may also use logic app connector.

 

thank you

Asif

Yes via apis and ethereum connector in logic apps to capture event data .