i had a look at it and uploading my process will be impossible. I use a lot of custom operators and i don't want to upload 35 xml files
But here's what it should look like : (Those are SLCM (cat) and Service Desk (sdm) webService methods)
cat : "logIn"
cat : "getRequestItemRow"
cat : "getRequestHeader"
cat : "getRateItemDefinition"
You'll have to loop in your requestItem to get form element values.
Store those values in JavaScript variables.
And now create your ticket in SDM.
sdm : "login"
sdm : "doSelect" to get pcat handle. (category persistend_id)
sdm : "getHandleForUserid" (requested for user persistent_id)
sdm : "getHandleForUserid" (requested by user persistent_id)
sdm : "createRequest" (With type R if you want to create a Request)
With SDM webService when you want to create a ticket, you have to pass value in a key-value string array :
This is a VB.net example.
attrVals(0) = "description"
attrVals(1) = newCR.desc
attrVals(2) = "customer"
attrVals(3) = newCR.userHandle
attrVals(4) = "requested_by"
attrVals(5) = newCR.userHandle
attrVals(6) = "type"
attrVals(7) = "I"
attrVals(8) = "category"
attrVals(9) = pcatVal
cat : "addTicketToRequestItem"
You can read SDM and SLCM documentation for webService method parameters.
You will have to parse XML value, wich are returned by SLCM webService method. If you want to avoid this you can go with SQL Queries.
In case you want to use SQL Queries, here's the one to get form element value from catalog :
select urif.form_elem_value from mdb.dbo.usm_subscription_detail USD
inner join mdb.dbo.usm_request_item_form URIF
on URIF.subscription_detail_id=USD.id
where form_elem_name = 'yourControlName' AND USD.request_id=yourRequestID
And it looks like this is your first step in Pam Integration. I wish you good luck, and be strong, it'll be a long way to master everything.