Discussions
API /api/queryservice/_execute need limit and offset
I've been using the new IQA service endpoint but haven't found how to limit the result set yet or change its offset cousin.
Typically it would be a GET /api/iqa?limit=500&offset=2000&queryname={IQA_Path}
but I haven't found any examples of that in the _execute endpoint.
Posted by Nicholas B Wimsatt over 4 years ago
Refresh token is empty
I have a client application that has been working perfectly for a long time and suddenly I am getting an empty refresh token. The only thing that changed was the manager password but I am pretty sure it worked after the change. Anyone have any ideas on what to look at?
Posted by Rick over 4 years ago
GroupMember POST API call.
We have created a GroupMember POST call to add a contact record to a committee. When we post this record it will delete any record that was already in the committee for that contact. Is there a flag or field that needs to be added to prevent this from happening?
Posted by Joshua Deville over 4 years ago
RequestVerificationToken not working but Authorization is working
Hi there I'm trying to run the Cart get , post and delete command but I'm encountering an error. When I perform the operation in Postman with the Authorization header everything works. When I attempt to use it via the RequestVerificationToken parameter for the client side iPart this command fails.
Ultimately I would like to have the client have the ability to add an item to the cart and be redirected dynamically.
Posted by Dave T over 4 years ago
UserSecurity is not implemented
Api call returns error: 501 Operation not implemented
See "Returns a list of UserSecurity"
From: https://developer.imis.com/reference/usersecurity
Posted by Molivouth Boulom over 4 years ago
Logout.asmx doesn't always work
We have an integration deployed in several of our client's iMIS installations. Part of the integration's behavior is to log the user out of iMIS. We use javascript to do that, like this:
requestToken = jQuery("#__RequestVerificationToken").val();
jQuery.ajax({
method: "post",
url: this.membershipServiceUrl + "/Logout",
headers: { "RequestVerificationToken": requestToken }
})
.done(function (data) { // success
MemberPrimeSSO.logoutRedirect();
})
.fail(function (data) {
MemberPrimeSSO.logoutRedirect();
});
It works on some installations. On others the Login cookie is not deleted and the user remains logged in. I used the Chrome JS debugger to confirm that the code is taking the success path.
Are there additional requirements for the Logout method of the membership service?
Posted by Larry Allen over 4 years ago
Facing issue while getting response from Huge Jason
Hello Team,
The process we are trying to build is to extract Data from iMIS on periodic basis and load into our Data Warehouse.
We are using C# and making rest API calls to extract Data.
We have few REST API calls that brings more than million rows, when ever we try to extract data the process fails after 100K records.
How can we extract larger set of data using REST API out of larger set of Data?
After the initial Loads, anyway we can get DELTAs via the REST API calls?
Please see below API details from our C# Architect, the api/Group has 1.3 million rows and fails after 100K rows.
we are applying paging while sending the API request.
while we are doing this , It is taking more time and getting time out errors. So please let me now if there is any easy way to pull huge data.
Let us know our options.
Thanks,
Koti.G
Posted by koteswar Rao over 4 years ago
Passing and Capturing Parameters for the Task
Hi This is regarding the post shared on help site.
https://developer.imis.com/docs/running-a-task-with-a-stored-procedure
This task is creating and running a stored procedure asi_GetCounter to give back the highest SEQN/Ordinal
But how can I pass the variable and capture the return value?
Also, the endpoint
https://{{URL}}/api/TaskDefinition/_execute
always returns null, I am not sure why!
Posted by Parteek Chhabra over 4 years ago
iMIS Cloud Rest API - Put Call
We are trying to make PUT call to BOs created by Panel in the cloud instance (20.3). It gives an 405 error.
GET for reading &
POST calls for inserting records are working.
So, need a scenario to Update a record.
Earlier POST calls were working even to UPDATE records, but I believe with recent REST changes(last week) in cloud , it has stopped working and POST endpoints are only for creating the records.
Here is the call we are trying to make.
var settings = {
"url": "/api/BCAPR_APPLICATION?ID=23155&Ordinal=1039",
"method": "PUT",
"async":false,
"headers": {
"Content-Type": "application/json",
"RequestVerificationToken": document.getElementById("__RequestVerificationToken").value
},
"data": JSON.stringify({"$type":"Asi.Soa.Core.DataContracts.GenericEntityData, Asi.Contracts","EntityTypeName":"CAPR_APPLICATION","PrimaryParentEntityTypeName":"Party","Identity":{"$type":"Asi.Soa.Core.DataContracts.IdentityData, Asi.Contracts","EntityTypeName":"CAPR_APPLICATION","IdentityElements":{"$type":"System.Collections.ObjectModel.Collection`1[[System.String, mscorlib]], mscorlib","$values":["23155","1039"]}},"PrimaryParentIdentity":{"$type":"Asi.Soa.Core.DataContracts.IdentityData, Asi.Contracts","EntityTypeName":"Party","IdentityElements":{"$type":"System.Collections.ObjectModel.Collection`1[[System.String, mscorlib]], mscorlib","$values":["23155"]}},"Properties":{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyDataCollection, Asi.Contracts","$values":[{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"ID","Value":"23155"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"Ordinal","Value":{"$type":"System.Int32","$value":1039}},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"Institution_ID","Value":"23166"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_ALERT","Value":""},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_ASSESSMENT_TYPE","Value":"NP"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_ATTEMPT","Value":"z"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_CCPTP_DOC","Value":"a"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_COMPLETED_DATE","Value":"0001-01-01T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_COUNTRY_OF_EDU","Value":"AT"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_CREATED_DATE","Value":"2020-04-16T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_CRITERIA_MET","Value":"a"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_DATE_DOC_RECD","Value":"0001-01-01T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_DUE_DATE","Value":"0001-01-01T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_EXAM_DATE","Value":"0001-01-01T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_EXAM_LOCATION","Value":"a"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_EXAM_PROCESS_ID","Value":"ss"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_FEE","Value":"a"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_OPEN_DATE","Value":"0001-01-01T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_OUTCOME","Value":"COMPLETE"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_PHASE","Value":"APP_IN"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_PROCESS_NAME","Value":"ALTEVAL"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_PROCESS_OWNER","Value":"a"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_PROCESS_TYPE","Value":"CRED"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_PROCESSING_WEEKS","Value":"a"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_RELATED_PROCESS","Value":"aa"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_REOPEN_DATE","Value":"0001-01-01T00:00:00"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_STATUS","Value":"REG"},{"$type":"Asi.Soa.Core.DataContracts.GenericPropertyData, Asi.Contracts","Name":"APP_UNIV_CONF","Value":"a"}]}}),
};
jQuery.ajax(settings).done(function (response) {
console.log(response);
});
Thanks,
Akshay Paladiya
Posted by Akshaykumar Paladiya over 4 years ago
Contact endpoint not filtering on MajorKey
working: https://imistour2847.imiscloud.com/api/CsContact?MajorKey=101
not working? https://imistour2847.imiscloud.com/api/Contact?MajorKey=101
Contact endpoint does not appear to be returning the same result as CsContact?
Posted by Molivouth Boulom over 4 years ago