-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathscript.py
More file actions
32 lines (26 loc) · 1.08 KB
/
script.py
File metadata and controls
32 lines (26 loc) · 1.08 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
from omniscope.api import OmniscopeApi
import os, pandas as pd, json
from slack import WebClient
omniscope_api = OmniscopeApi()
client = WebClient(token=omniscope_api.get_option("authToken"))
methodType = omniscope_api.get_option("methodType");
if ("POST" == methodType):
response = client.api_call(
api_method=omniscope_api.get_option("methodName"),
http_verb=omniscope_api.get_option("methodType"),
json=json.loads(omniscope_api.get_option("jsonPayload"))
)
else:
response = client.api_call(
api_method=omniscope_api.get_option("methodName"),
http_verb=omniscope_api.get_option("methodType"),
params=json.loads(omniscope_api.get_option("params")),
)
output_data = pd.DataFrame(data=pd.json_normalize(response.data))
output_data_2 = pd.DataFrame(data=[response], columns={'Text Response'})
#write the output records in the first output
if output_data is not None:
omniscope_api.write_output_records(output_data, output_number=0)
if output_data_2 is not None:
omniscope_api.write_output_records(output_data_2, output_number=1)
omniscope_api.close()