Skip to main content
Question

Is there any way to "decrypt" the data from A360 DB --> WORKITEMS table --> 'json' column??

  • January 31, 2023
  • 2 replies
  • 65 views

Andoni_1
Navigator | Tier 3
Forum|alt.badge.img+10

Hello,

 

I want to build a power bi dashboard that fetches data from A360 DB. Most precisely I want Power BI to fetch the data of the workitems processed.

 

I see that this data is contained under WORKITEMS table. However, if a queue has more than 10 columns, the data (presumably) needs to be queried from the ‘json’ column of this table:


How can I decrypt this data?? I think that it’s using RSA for encryption, but I have no idea about where is the key for this…any help would be appreciated

 

2 replies

rbkadiyam
Premier Pathfinder | Tier 7
Forum|alt.badge.img+17
  • Premier Pathfinder | Tier 7
  • January 31, 2023

@Andoni  PRIVATE keys will be available here for decryption

 

 

 


Andoni_1
Navigator | Tier 3
Forum|alt.badge.img+10
  • Author
  • Navigator | Tier 3
  • January 31, 2023

@rbkadiyam have you personally tried to decrypt what I say with those keys?