Hi Marc,Sorry for the late response, but for now we did not have time to break down the procedure, (the show had to go on). So for now we leave it as it is, because it happens incidential.Thanks,Randolph
Hi Mark,Thanks for the response. It doesn't look like it. It is also reproducible. If I mail the same mail with the mail attachments to the relevant mail box to be imported then it is imported without attachments. If it is a PDF, then it goes well. Greetings,Randolph
I must add that the post changed from multipart/form to application/json.
Hi All,I managed to use both a process flow and a sql statement to call the OCR api. Below is the code for those interested: declare @token int;declare @ret int; declare @url nvarchar(max);declare @authheader nvarchar(64);declare @contenttype nvarchar(64);declare @apikey nvarchar(32);declare @body nvarchar(max);declare @json table(json_table nvarchar(max));set @url = [endpoint]set @body = [base64 content]exec @ret = sp_oacreate 'msxml2.xmlhttp', @token out;if @ret <> 0 raiserror('unable to open http connection.', 10, 1);exec @ret = sp_oamethod @token, 'open', null, 'post', @url, 'false';exec @ret = sp_oamethod @token, 'setrequestheader', null, 'content-type', 'application/json';exec @ret = sp_oamethod @token, 'send', null, @bodyinsert into @json (json_table) exec sp_oagetproperty @token, 'responsetext'select * from @json
HeyThe wish has changed somewhat. If a new document is added to the table, the above stored procedure must be fired. So not by means of a schedule, but an on insert trigger. So I am curious how this stored procedure should look like.I am also curious (in case of a process flow) how the input parameters should look like in the http connector in case of a multipart/form-data, like in the screenshot below:Many thanks advance.Randolph
Hey Mark,Thanks I will try that. Thanks for the tip.Regards,Randolph
Hello René, Thanks for the reply. I want use this procedure as a scheduled SQL job, so there will be no user intervention.
Hello René,Yes, it sure does. Thanks for the alertness.Greetings,Randolph
Hello Jeroen,Somehow, my reply above wasn't quite the true after all. It turns out that SQL job failes when new users are to be added. Today I put some time into it and found that the update trigger "usr_tu” on the table IAM.dbo.usr was generating the exception. If I set the trigger to disabled then the SQL job was succesfull. If I enable it it will fail again and the SQL job will not be able to add new users to IAM. Next I commented out the following part in the function "is_authorized_usr_admin”: else if not exists( select 1 from usr_manager a join usr c on c.usr_id = a.usr_id where a.usr_id = dbo.tsf_user() and (a.begin_on is null or a.begin_on <= getdate()) -- start of authorization period and (a.end_on is null or a.end_on >= getdate()) -- end of authorization period and (c.begin_on is null or c.begin_on <= getdate()) and (c.end_on is null or c.end_on &g
Hello Jeroen, Thanks for the reply, I changed the owner. I emptied a user group in IAM and had the job imported according to schedule and that worked. Thank you very much. Regards, Randolph
Hello Jeroen, Thanks for the reply. If I use the same user (service account) for the AD sync task in IAM I will not receive the exception and new users are added to the User groups. The SP which is scheduled uses also these credentials. If I manually start the job the job runs fine even if new users needed to be insert into the group. SP with service account credentials: Sales group which is emptyEmptyActive Directory Sync Task with same account as SPAccounts are added So it looks like the service account is having sufficients right. Is this assumption correct? Thanks in advance, Randolph
Hello Erik and Sebastiaan, Well in that case. Thanks for the reponse. This does answer the question. Greetings, Randolph
Hello Vincent, Seems the mandatory parameters solved the [Stage task commit failed. Error: validation_failed] issue. I think I am too new for this, but where can I find the Universal GUI Developer Tab? Thanks in advance, Randolph
Hello Anne, Thanks, I will create a ticket in TCP.
Hi That is much better: Now you probably want to know what the Creation Process does. I will let you know.
Hi Anne, I will do and let you know
Hello Bart, It says 1.44 (inactive) and I am working in 1.45 at the moment. Tab [List] shows this: Thanks in advance.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
