# Web Dev -API 500 server error

**URL:** <https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [May 16, 2024, 5:24am UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471 "2024-05-16T05:24:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohd\_Waqas](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Mohd\_Waqas](https://forum.inductiveautomation.com/u/Mohd_Waqas)\
**Post date:** [May 16, 2024, 5:24am UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471/1 "2024-05-16T05:24:46Z")

</div>

Hi- I'm facing issue while using webdev endpoints API in another applications like angular17...etc.  
when I recalled enpoints from webdev from ignition without using database connection its look like proper working with other applications and after database connections in API endpoints scripts using namedquery and runprepquery it show me error....500 server error.  
and I used all headers also in script still showing error- 500 server error, any suggestion on this error how to resolved?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/62c7a6db33e4f00db5b497af657862b8af142562.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 16, 2024, 5:57am UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471/2 "2024-05-16T05:57:48Z")

</div>

Look in your gateway logs to see the actual error messages.

---

<div class="post-metadata">

**Author:** ![Mohd\_Waqas](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Mohd\_Waqas](https://forum.inductiveautomation.com/u/Mohd_Waqas)\
**Post date:** [May 16, 2024, 10:48am UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471/3 "2024-05-16T10:48:08Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/5/f53bcc8f0441ffcbab2373105e791ba6b15611b8.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/0/f0251e0e7508211b10159aed5ae7a48f020f3e5d.png)

showing this for web-dev API endpoint.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 16, 2024, 12:14pm UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471/4 "2024-05-16T12:14:10Z")

</div>

Your screenshot indicates the error is at line 82 of your script.

(Please post code **as code** , not screenshots. Tracebacks, too. Use the forum comment editor's "preformatted text" styling button.)

---

<div class="post-metadata">

**Author:** ![Mohd\_Waqas](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Mohd\_Waqas](https://forum.inductiveautomation.com/u/Mohd_Waqas)\
**Post date:** [May 16, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471/5 "2024-05-16T13:10:08Z")

</div>

def doPost(request, session):

```
servletResponse = request["servletResponse"]
servletResponse.addHeader("Access-Control-Allow-Origin", "*")
servletResponse.addHeader('Content-Type','application/json;charset=utf-8')     
servletResponse.addHeader('Access-Control-Allow-Methods',	'POST, GET, OPTIONS, DELETE')
data = request['postData']

uname = request["data"]['userName']
fname = request["data"]['fName']
mname = request["data"]['mName']
lname = request["data"]['lName'] 
email = request["data"]['email'] 
phone = request["data"]['contact']
city = request["data"]['city']

try:
	query = " insert into test.dbo.clients (FirstName, MiddleName, LastName, UserName, Email, [PhoneNumber], City) VALUES(?,?,?,?,?,?,?)"
	
	args = [fname,mname,lname,uname,email,phone,city]
	
	data = system.db.runPrepUpdate(query , args, databaseConnection = 'newclient' ) 

	return {'html':"New User Added"}
	
except Exception, e:
	return {'html':"failed"}

```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 16, 2024, 1:16pm UTC](https://forum.inductiveautomation.com/t/web-dev-api-500-server-error/90471/6 "2024-05-16T13:16:31Z")

</div>

The implication of the error is that `request['data']` is an array, not a dictionary. You should log that content to verify you have the structure you expect.

( You didn't quite get the "preformatted text" styling correct. You should edit your comment to fix it. )