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
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive