Loading a log file in JSON format
The workbench allows us to load JSON formatted log file. I dont see any examples indiating what the "data source" examples could be. It indicates a key what would the key be?
Below is an example of what im looking to load and take in values for calculation , the values are all mocked up but this is what we would think to see :
{"interaction":{"startTime":"2018-10-12 08:55:15.998","name":"FactButton","qualifier":"field_149-or_so_Step5Submit-7197--Order-Submit_B","context":{"classKey":100,"rootKey":29430,"effectiveDate":"2018-10-12 08:54:32.000","activeTab":"Product Order / Enquiry","id":null},"httpRequestCount":0,"rpcCount":18,"rpcDuration":10985,"rpcMin":4,"rpcMax":9948,"sessionId":"DAEE8FC913849170784348576FC7629F","hostName":"tester","serverName":"example","remoteHost":"192.168.0.1","error":false,"warning":false,"windowClosed":false,"totalDuration":11386,"user":"testuser"}}
{"interaction":{"startTime":"2018-10-12 08:55:52.645","name":"DialogButton","qualifier":"OK","context":{"classKey":100,"rootKey":29430,"effectiveDate":"2018-10-12 08:54:32.000","activeTab":"Product Order / Enquiry","id":null},"httpRequestCount":0,"rpcCount":0,"rpcDuration":0,"rpcMin":9223372036854775807,"rpcMax":-9223372036854775808,"sessionId":"DAEE8FC913849170784348576FC7629F","hostName":"tester","serverName":"example","remoteHost":"192.168.0.1","error":false,"warning":false,"windowClosed":false,"totalDuration":97,"user":"testuser"}}
Comments
-
Hey there!
The JSON you provided is invalid. Each grouping you have uploaded can be counted as a single row in a JSON file, but because of how they are encapsulated, it separates them out so each row acts as its own JSON file. You will need to check the process that is generating these files.
Here is Domo's Knowledgebase article on how to pull in a JSON file from Workbench - https://knowledge.domo.com?cid=wb4json
If you need help from Domo resources, you can go to your Customer Success Manager or Account Executive, and they can help point you in the right directionl.
Thanks
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive