We are stumped by this problem, as the addin appears to work and just fails to work for one particular user when doing REST-API calls using the PAx API. the user can refresh the sheet or use Formulas like DBRW, DBSS, and calls to the PAx API like Reporting.RefreshSheet work perfectly fine. For this particular user the Call fails with "Runtime Error 91 Object Variable or With block not set". This code works for every user of the Excel files but for one. Reporting.GetConnection(sPAW_URL).Get("tm1/" & sDatabase & "/api/v1/" & endpoint & "?" & params) In some Excel files we make requests to the TM1 REST-API using the following code: We are using the PAx API in our VBA code. Why does a trailing "/" only crashes on some systems? We have found the issue to be a trailing "/".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |