wrong details are inserted through API's, though josn details are correct

yashwantsharma968

Hi Team,

I am trying to create bulk tickets through Osticket APIs using Java. I have printed my JSON and can see that the data is correct, but when it's replicated in Osticket, the data of name and email is repeated, though apart from that, every other detail of the ticket is unique similar as what is in the json. Tried clearing cache also but not sure why it's happening.

KevinTheJedi

yashwantsharma968

Can you provide more information and better screenshots?

Cheers.

yashwantsharma968

Hi Kevin KevinTheJedi ,

Thank you for your response. We're currently developing a lead management solution that will automatically pull details from our database and feed them into osTicket. Our product manager will then review and manage these leads through the ticketing system.

I've written a Java program that sends data to the osTicket API in JSON format. The goal is to create tickets in bulk, and each user in the system has a unique ID, name, and email. However, while attempting to generate around 2500 tickets, I noticed an issue: for some users, the name and email fields are incorrectly being repeated across multiple tickets. For example, a single user ends up with around 1500 tickets, even though the other 18 fields are correctly populated with unique data. This problem isn't occurring with all tickets but happens intermittently.

In summary, out of the 20 ticket fields, 18 are correctly reflecting the data, but the name and email fields are occasionally being duplicated across multiple tickets.

Could you provide some insight into what might be causing this issue?

Thanks!

KevinTheJedi

yashwantsharma968

If I were you I would review at the script to make sure it’s not repeating anything. 9/10 times it’s the script as osTicket simply uses the data it’s given.

Cheers.

yashwantsharma968

KevinTheJedi How should i share the script with you ? any email id?

KevinTheJedi

yashwantsharma968

Oh, I won’t review the script as it’s custom. You would need to review it yourself.

Cheers.

yashwantsharma968

KevinTheJedi Kevin I have reviewed it and even printed the JSON separately before feeding to API there it's fine. When the data is reflecting here then it's getting changed.

KevinTheJedi

yashwantsharma968

How fast are you sending the requests? Have you tried sending them slower and seeing if that makes it better?

Cheers.

yashwantsharma968

KevinTheJedi yes I have tried that... I have implemented a sleep time of 2 seconds still same response.

KevinTheJedi

yashwantsharma968

Then something isn’t right with the script or your setup.

Cheers.

yashwantsharma968

KevinTheJedi Kevin I can share the 2 script response just before sending it to the osticket where in one it will take all the correct fields and in other only name and email variable will be changed.

KevinTheJedi

yashwantsharma968 Post the script..

KevinTheJedi

yashwantsharma968

What is all that?! I thought it was a simple script. Well I can’t really do much with that so I’m not really sure how to help you unless you can track this down in the codebase. You can add debug statements to the code in various places to see at which point it’s assigning to a different user than it’s supposed to. I will say we have many clients using the API daily sending many, many requests and we haven’t heard of such issue; especially with the latest releases.

Cheers.

yashwantsharma968

KevinTheJedi
Have a look at these 2 responses. One is codebase generated json before pushing it to API and another one is the Osticket ticket details. I hope you will have a clear picture now. Ticket no is same and check at name.

KevinTheJedi

yashwantsharma968

…the email address is the same so of course it will go to the same user. The email address is the unique identifier for users and agents.

Cheers.

yashwantsharma968

KevinTheJedi Ok got it. So actually i set a default email id if there is no mail id. I was not aware about that. So sorry for all the trouble and thanks for the all help.