Thinkwise Platform

Hello all,Does anyone have an example of an t-sql request against a REST API with a Multidata/Form? We already call several REST APIs, but not with Multidata/form. Below is a setup (which does not work). The API converts a PDF document into fields in json format. It contains 2 fields that must be included:name (name of the document) document (base64 encoded string)Below is a first attempt, but it does not work :-). Thanks in advance for the reactions.declare @response table (txt nvarchar(max)); declare @object int , @url_endpoint nvarchar(200) , @response_format nvarchar(5) , @request nvarchar(250) , @json nvarchar(max) , @address address , @body varchar(max) , @status int , @d

We are looking to upgrade our TW software to version 2022.1, and during my tests I encountered some performance issues while synchronizing our latest version. Our performance monitor pointed towards the function look_up_chain_granted. This function is called around 1.5 million times, as our application contains a high amount of Roles. At 1.25ms per execution this could take a very long time. The performance index suggested adding the index stated below and this decreased the avg execition time to 0.075ms, which helped with decreasing the total sync time from almost one hour to just ten minutes.I would suggest Thinkwise take a look at this suggestion as it has helped us very much.CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname, >] ON [dev_sf_upgrade_test_2022].[dbo].[ref_col] ([project_id],[project_vrs_id],[target_col_id]) INCLUDE ([abs_order_no]) 

The project I am working on needs to fill a form (which is developed in SF) by the candidates. This form will be sent as the link to the candidate in an email. When the candidate clicks this link it should take the candidate to the form. My question is :If the candidate does not have the log in details for SF , can he still open and save his data through the form?  Can the universal GUI url open without user id and password?

Hi. I am trying some cubes and charts. Why do only column values get shown the elements, as when they are added as a row they get their DB values. Socio Type (Combo with Elements), as a column and states as rows I see the named elements.  Socio Type (Combo with Elements), as a row I see the DB values instead of elements.  

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government.I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings.   Settings in OAuth servers      White screen. Nothing happening.    My proces flow 

What could be the reason a query is taking way more time through the GUI than direct on SMSS? If I copy this query into SMSS and execute it, it's done instantly. While via the GUI it takes quite some milliseconds. 

What can be the reason that the initial connection takes seconds…  I have another query that runs 5 ms direct on DB..  and this time I see that it stays for seconds in initial connection.   and after 6.7 minutes it's done.. 

The license is not automatically renewed.The registration has been successful.Starting the IIS application manually also works fine; when i start it as administrator as well when i start it as de pool-user.Automatically it does not work.I'm working with the installation 2021.1I have checked the problemsolving: idle-time is set to 0 and startmodus is AlwaysRunning. The authorization on the wwwroot-map is set correctly.So beats me. What can i do? Who has any ideas?

I have a table with over 48 million records and I would like, besides some default pre-filters, to have the filter form pre-filled with an option and let the user alter these selections ( they are combo's). On of them is company type, can I give these fields by default a value and make sure that they cannot be empty? 

What is the reason that the dbEventLog is not reachable? This site can’t be reachedThe webpage at https://coragem.lef.tec.br/indicium/account/ui/dbEventLog might be temporarily down or it may have moved permanently to a new web address. The Universal is directly pointed to the SF. And will this also be available for the Indicium log?  Now I have to every time go to the indicium URL download the log file..  would be easier to see it online with the latest messages. 

Hi,Recently I have been encountering some problems with the OData api because of some code written in the stored procedures. Up till now I noticed that the layout and default CP have effect on the api. For instance: I had once written in my layout CP to set some fields on Read-Only if a certain condition is met. Turns out that these fields are also set on read-only for the api, which results in not being able to update the field via a mobile app and getting a 403 error.  Now I have this piece of code (as show below) which I thought would only effect the gui because I specifically added the ‘@cursor_from_col_id’.But now when I use the api to update a record, the status is always set to ‘RGS’ because I have a service type that is not equal to ‘OTH’. Removing the field from the request still doesn’t seem to help this issue.How can I tackle this issue? Is there something that need to be aware of?Thanks

I’ve deployed the latest version of Indicium universal to Azure according to the instructions (https://docs.thinkwisesoftware.com/docs/deployment/azure#creating-an-azure-web-app). Unfortunately  the application does not start with message:HTTP Error 500.30 - ASP.NET Core app failed to startThe event log has more information:Application '/LM/W3SVC/1165921035/ROOT/indicium' with physical root 'D:\home\site\indicium\' hit unexpected managed exception, exception code = '0xe0434352'. First 30KB characters of captured stdout and stderr logs:Unhandled exception. Internal.Cryptography.CryptoThrowHelper+WindowsCryptographicException: Access is denied. at Internal.Cryptography.Pal.StorePal.FromSystemStore(String storeName, StoreLocation storeLocation, OpenFlags openFlags) at System.Security.Cryptography.X509Certificates.X509Store.Open(OpenFlags flags) at Indicium.Startup.getOpenIdSigningCertificate() in C:\azp\agent\_work\1\s\src\Indicium\Startup.cs:line 868 at Indicium.Startup.configure

I am working on an App and I want to incorporate the economic activities.. these are available via public API. (https://servicodados.ibge.gov.br/api/v2/cnae/subclasses) How do I process this? Because I know use a NVARCHAR(MAX) variable, but I don't think it can hold the whole result?  37.8 MB ..   However it does process but only a part of all the economic activities.  Is there a way to save the JSON as a file and later on process it? 

We have a requirement for which we need to ensure that in a set of rows at least one of the rows does not have an end-date. In below example it should not be allowed to add an end-date to test=3.@Robert Jan de Nie Is it possible to use check constraints to prevent this? 

I have added the following three icons in the menu for the Universal GUI, all svg. 1. Heart icon #0044872. Heart icon #0000003. Colour pallet  SF | Menus - DesignWhy does the Universal GUI only show the second icon? The other two icons should be visible in their original color in dark/light mode, right?   Universal GUI - 2022.1.11 b1.0 

Hi!We’re trying to automate our merging and branching with the SF. As stated in this question it’s already possible to execute a merge session, however I'm trying to also create the merge session. To do this I'm executing the following API call: POST indicium/iam/sf/start_merge_session{ "trunk_project_id": "TRUNK_ID", "trunk_base_project_vrs_id": "1.00_TRUNK_ID_BRANCH_ID_BASE", "trunk_current_project_vrs_id": "2.00", "branch_project_id": "BRANCH_ID", "branch_current_project_vrs_id": "1.00", "merge_direction": 1, "description": "Merge TRUNK_ID 2.00 into BRANCH_ID 1.00",}However this is returning a 403 Forbidden, am I doing something wrong or is it not yet possible to start a merge session with an API call?

Since Thinkwise itself doesn’t profile itself as a bookkeeping system, we have realized an integration with Exact Online for our Thinkwise application. This was recommended by Thinkwise because the integration is relatively easy due to similar code. However, it appears the integration still comes with a log of bugs and errors. Also, our customer isn’t fully satisfied with the working of Exact Online.Are there any other options/recommendations for a bookkeeping system? How do large Thinkwise customers do this (e.g. VDL Nedcar or Zeeman)?Also, how to archive invoices from Thinkwise (as they should be archived for at least 7 years)? Currently we can regenerate an invoice, but we only store data for 2 years. Could this be done efficiently in Thinkwise for 7 years? Or is it perhaps recommendable to archive every single pdf in another database?Any other ideas/suggestions?

Hi,I’m currently getting the following error on generation step “Execute: create_log_tables” in the Generate Definition step of my creation: Error messageError lineI don't know what could have caused this, is anyone able to give me a suggestion as to how to solve this?Thanks in advance.

When you make alterations to the model, especially the data part that results in an upgrade script. What are the best practices when someone create something that is not accepted by the database. In this case the you can choose to ignore and go on or to abort. To not loose data it's best to go for the abort scenario. But then you get stuck with all the renamed tables and all or partially the new tables already. When you fix the problem, there seems to be no easy way to rerun the upgrade script because with every existing you get an error..  so 130 tables renamed and 130 tables new = 260 messages.. Can there be an option to just ignore the messages?  Or can there be an option to roll back the situation by deleting the new tables and renaming the backups back to its original name? Now I just 'hack' my way through it via SMSS, but perhaps the SF can offer something more elegant. 

Hi,I have tables which have a is_deleted column. Now I want to make a clear distinction where is_deleted = 1. I can do this with conditional layout where the background color is specific color, but adding this for each table is very time consuming. fyi: My application is in Universal GUI.Is this possible with the dynamic model? If so, how should I do this? Thanks

I have a cube view with cube view columns sorted descending. When I show the cube with the SF model, it works fine. But when I synchronise it to IAM, it does not sort the columns descending anymore (2021.2). Only when I use the ‘sort by cube field’ (not mandatory) it works also in IAM. Is there a reason for this behaviour? 

Hello,We are using the Exchange connector to process e-mails, which arrive on a certain e-mail address, within our ticket system. These emails often contain attachments and are saved using the sendGetAttachment + saveAttachment. However if the attachment is an e-mail the @byte_array will be NULL and will not be saved. Does anyone have an idea why @byte_array is NULL when the attachment is an e-mail?Thanks in advance.Greetings,Randolph 

I created a unique index and I deployed my project. When I try to delete this index I am getting“An explicit DROP INDEX is not allowed on index ‘ sales_person.unique_sales_person’ . It is being used for FOREING KEY constraint enforcement.”error message.I tried to clean install but it didn’t work. It is in software factory version 2022.1How can I solve this? 

We need to transfer our real-time freight data via an XML file to our carrier. In what way can I do this safely using Thinkwise?Is an FTP link secure enough for this? 

Has anyone figured out how to implement barcode scanning in the Universal GUI. At this moment when I scan a barcode in a TEXT field the GUI does not perform an ENTER. So the value is Shown in the field but, the value is not processed by the default because the GUI does not handle the scanning action of the terminal as an entered value. (I already tried different settings on the scanner like HEX suffix 0X0A (Which is the equivalent of ENTER) But the universal GUI seems to ignore this suffix. So the result is that the value is shown in the field and the user always need to do something on the screen. We need to scan a barcode, process it’s value in a default, moves the cursor to another field or the same field. For example, scan a product barcode, scan a location, scan a product barcode, scan a location. A created a test form with only 2 fields and want the default to handle the scanned value and moves the cursor to the following ‘to-be-scanned’ field. Someone has ideas??? declare @msg v