API on Windows

cdwilson

Hi All

I am really struggling with how i can schedule ticket creation using the API method.

I have read the following documentation.

https://docs.osticket.com/en/v1.14.1/Developer%20Documentation/API/Tickets.html

And also read another thread that says on wiindows i need to use php-cgi.exe

This is not something i have ever done so getting very confused, what command do i need to run and do i need to create multiple /api/tickets.xml files for each ticket that i want to create?

ntozier

You would write a script to open the ticket that you want to open.
Then you would use your task scheduler (windows) or cron (linux) to schedule the script to run when you want it to run.

Regardless of what os you use you would have to pass the command line to the PHP interpreter.

So if your PHP is at C:\PHP\v7, and your script was at C:\nightly\script.php
Then the command would be something like"
C:\PHP\v7\php.exe -f C:\nightly\script.php

cdwilson

OK so i have found some articles online and can confirm that i have created an API key and have added the following script and made the changes to the API and URL as it says.

https://github.com/sharmaghanshyam/Osticket-Creation-API/blob/master/ost-api.php#L81

and also placed Tickets.json tickets.xml into the api directory on my webserver, do i need to edit these or just use the examples from the OSTicket website?

Do i need to now create another script to create the custom tickets that i want, does anyone have an example that i can use on windows?

ntozier

This is pretty old (and I have been working on an updated version of the article) but the vast majority of this is still the same. (attachments have changed).

https://tmib.net/using-the-osticket-1-8-1-2-api/

cdwilson

So just to be clear this is the script i should be using for creating my tickets via task scheduler, ie i would need to rename this scripta few time for my different tickets i want to create?

I have updated the script to include my api and url.

I am getting unable to create ticket so enabled debug, however it doesnt really make any sense.

Array ( [name] => John Doe [email] => john@gmail.com [phone] => 1234567890 [subject] => Test API message [message] => This is a test of the osTicket API [ip] => 192.168.0.10 [topicId] => 1 )

Any ideas?

ntozier

If it doesn't work then you likely have a custom required field that you will need to populate.

cdwilson

The only required ones i have are the 4 normal ones and also one for Organization Information with the variable name.

However i cant undo this one from being required, how do i define the organization name due to the varaible name also being 'name' ?

cdwilson

Also i have noticed the following error in my php logs
Undefined index: REMOTE_ADDR in ost-api.php on line 44

however when i run the php file using a web browser the correct ip displays.

mbrctv

The $_SERVER['REMOTE_ADDR'] variable is populated because of Apache, running from the command line, this variable won't be set, as well as many others

mbrctv

You need to get your IP. when you run with PHP CLI you can't get the IP form $_SERVER['REMOTE_ADDR']

https://stackoverflow.com/a/6256719/12239849

cdwilson

Anyone know how to get some more logs for why the api script is not working?