RESTful API to Create Lookup Fields?
Can a RESTful API be used to create lookup fields using a pipeline? Or, can anyone suggest a faster way to create 130 lookup fields for a use case in which I have 130 relationships between two tables (I need a new lookup field for each relationship)? I'm hoping to find a faster way of doing this other than manually one-by-one.
File Name for PDF attachments
I'm creating a reoccurring notification with a PDF attachment. The attached file name is only showing as "document-1". The pdf is created through the document template and I'm able to already save it with a specific file name. How do I change the file when it's sent out as a PDF attachment with the notification?
Error message trying to connect to Netsuite
I'm attempting to create a connection with Netsuite and I get this error message. ERROR: duplicate key value violates unique constraint "ServiceTableDefinitions_pk" Detail: Key ("SessionId", "SessionResourceId", "ServiceTableDefinitionId", "LCName")=(t20434735s121413_38826vFk1JV2DG6CAVTXW25SDDXSBW4NM, 1JV2V7HFGFHT8V7ZP11D3V5SK, , country) already exists. I don't know what it means. Any help would be appreciated. Scott
Assigning User to Group if Not in Group
Hello, I would like to set up a pipeline to call API_GetUsersInGroup when a record is created and check to see if the user in a particular user field is in the group and if not, add them using API_AddUserToGroup. I am struggling to find a way for it to see that the user is in the group and stop the pipeline if they are not. Instead, it always shows they are NOT in the group and tries to add them, erroring out when they are already in the group. I'm fairly new to all of this, so apologies if it is a silly question - but how can I have it search through the results of API_GetUsersInGroup for my user and correctly identify if they are already in the group? I appreciate any assistance!How to fetch all apps across the Admin user account and their share permission data through APIs?
Hi Team, While exploring the Quickbase application i want to fetch the application data across the Admin User account including all the applications that are created by other users of the account. Being Super Admin I am able to see the applications of the other users from UI in the Admin console. I want to fetch this information through the API, while I am unable to find the REST API that fetches this data, is there any REST API available that fetches list of all application across the user account including the other user's apps. I tried using the XML based API and found that the API_GrantedDBs gives the apps created by the Super Admin user but was unable to give the other user's application in the list. How can I find the list of all applications across the user account including the other user's app. I am using the authorization ticket that is required to call the API. Please guide me for the same. I also require to find the users and groups that have access to the apps through the APIs. Please help me in finding the above points, if the APIs are not available is there any another workaround to get this data? Thanks.Exchange a SAML assertion for a Quickbase token
Hello, I am looking to use a SAML assertion for authentication of a custom web app that uses the QB JSON API. In the linked documentation, it is described that you can use an API endpoint to do this, thereby authenticating your app using the currently logged in user with a SAML assertion exchange. But the documentation is super vague and provides little for one to go off if you are not a SAML expert. https://developer.quickbase.com/operation/exchangeSsoToken The line from this documentation I linked to that I am focusing on, is this: You must be able to create a SAML assertion in your code to use this endpoint. Does anybody have documentation or advice on how to put the SAML assertion together? I want to link to my app from Quickbase using a Formula URL. Then I want my app to authenticate the current user so they can perform some tasks in my custom app under the same identity they were using in the QB app. I would love to see a full example, code and all, to help with this. (Minus any secure pieces you need to obscure.)Retrieving a record using a code page...
Building on the method described in the link below to post to Quickbase using an HTML form and EOTI access, is there a way to retrieve records to a similar form using an rid in a custom URL link (or any other way)? If so, how would you do it? https://community.quickbase.com/discussions/quickbase-discussions/posting-from-an-html-form-directly-to-quickbase/90206API Edit mobile forms
Hi guys. I used the text below to create a button to update a text field. It works perfectly on desktop but on mobile it updates the field several times which I see since I track changes to that field. Any idea why it works on desktop but not on mobile? var text Approve = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=myapptoken&rid=" & [Record ID#] & "&_fid_295=Yes"; // change the 99 to the field ID# of the checkbox field var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
