KeyError issue - unable to find root cause

[simms7400]

Hi Buran -

Not quite - I do not do anything manually. Within my ticketing system, there is a "Custom Schedule" module where it runs a query behinds the scenes (Sql query). Then the output of that (i assume JSON format) is passed as an argument - see picture.



The screen shot in my previous post is the "module" which runs the query - I did it manually so I could show you.

[buran]

in this case I don't know how we can help you - we don't know how your input data look like and why there is no emialid key. ignore my previous post if it is not csv file.

you can print workorder_list to see if you can guess what you are working with

[simms7400]

This isn't printing:

print(workorder_list)

Am I doing it wrong?

[simms7400]

Hi Folks -
Just wanted to bring this to the top. I did some more testing and the sys argument is as follows:

C:\ManageEngine\ServiceDesk\bin\..\integration\custom_schedule_reports\15301_csh.json

So, in fact, the argument passed is the json file called "15301_csh.json". This file (as shown above) is comprised of there columns persay with the following headings - in this order:
workorderid
emailid
createdtime

Does that help clear things up a bit? I'm still getting the following error:

Schedule : Aging_Open_Requests executed, Result: Traceback (most recent call last):
File "date_diff.py", line 17, in <module>
date = getdate(req['createdtime'])
KeyError: 'createdtime'

It seems as though it can't get the 'createdtime' column value in the json file. Any ideas?