I keep getting `Failed to commit. Status code: 500`

W

wallyflopsOP•9/24/24, 10:06 AM

Which just seems non descript

W

wallyflopsOP•9/24/24, 10:07 AM

I'm fairly confident my bearer token is correct, as I get that replying successfully.
I am fairly confident my liveboard_guid is correct, I'm getting it from row one on the TML.

W

wallyflopsOP•9/24/24, 10:09 AM

^^I stuck the above into the forum, maybe that's more appropriate

AAditya Hi @Nikhil Kumaran S You can customize the liveboard URL but you will not be abl...

R

RT•9/24/24, 2:26 PM

@Nikhil Kumaran S : Pls check info provided by @Aditya and @Anand Pushpraj . Few Q's:
1. Do you have dedicated cluster or on free-trial sign up on multi-tenant cluster? What version of TS cluster you are on?
2. Sender From Email and Email Domain can be set. There are TSCLI command which can be run via SRE

J

jmmiz•9/24/24, 2:54 PM

Hey everyone, we are looking to export liveboards, worksheets, etc from one organization and import them to another organization. We are trying to use the cs_tools scriptability command, but it seems it's only supported for environments in a singular org. We only have 1 environment in our organization, does anyone have experience with CS tools and migrating between organizations?

J

James Lunan•9/25/24, 2:57 PM

Hey all, we are having some issues with French translations of the Embed. When the browser is changed to French, we do not see any of the TS menus change to French as expected. Based on the user docs, I don't believe we should need to do anything special for translations to occur. Can anyone provide some troubleshooting, and assistance? The embed snippet is in this thread.

A

Alfredo•9/25/24, 10:24 PM

Hey team, we are trying to handle some errors using the EmbedEvent.Error, and I was wondering what your recommendations are for identifying specific errors.

We have noticed that some of the errors have a code and an error code (please see the screenshot below). Is there a way we can access the list of error codes? Maybe we can do something like this:

if (error.data.error[0].extensions.code === 12121) {
console.log("Error message for code 12121");
}

if (error.data.error[0].extensions.exception.message.includes('Error Code: QUERY_TIMED_OUT')) {
console.log("Error message for QUERY_TIMED_OUT");
}

R

Raaghul Umapathy•9/26/24, 4:21 PM

Hi
For the liveboard embedding, we are specifying the nonprod org and it only can access prod liveboards. If I try a non-prod liveboard it asks to switch orgs in the embed. Is there a way to skip the option of choosing the orgs?

P

Praveen K•9/26/24, 4:44 PM

Hi team, I am trying to update the Tag through REST API V2, but I am receiving the following error:

M

Mohsin Manzoor Bhat•9/27/24, 11:38 AM

@shikharTS @Aditya
Hope you are fine !
Myself Mohsin from FourKites.
Neelanjan Ghatak suggested me to talk with you.
We are facing issue with SAML SSO Setup.
Here is the case link
Can you please check this and let me know if you need any other detail from my side.

https://community.thoughtspot.com/s/case/500Uk00000G1gjxIAB/forbidden-403-on-sso-integration

B

Benedict•9/30/24, 6:46 PM

can I get an update on this? dev-help

A

Alfredo•9/30/24, 11:00 PM

Hi team, just wondering if there’s a way to change the error message text in the UI. For instance, for the "Query Timed Out" error in the screenshot below, we would like to display a different message, such as: "There was an error loading the data."

B

billsaysthis•10/2/24, 3:57 PM

What happened to customCSSUrl? I just updated the SDK from 1.23 to 1.32 and I get a Typescript error that this field is no longer part of customizations.style. This is a breaking change.

M

Mohsin Manzoor Bhat•10/3/24, 9:59 AM

Is Develop tab also visible for Secondary Orgs ?

B

billsaysthis•10/7/24, 3:57 PM

Hi, we're trying to use a runtime filter for one of our pages that embeds a liveboard (using the React SDK LiveEmbed component) and having a problem. I'm passing the following to the runtimeFilters prop but it isn't causing any change to the liveboard.

[
          {
            columnName: 'True Open',
            operator: RuntimeFilterOp.NOT_IN,
            values: ['Bot', 'Likely a Bot'],
          },
        ]

[
          {
            columnName: 'True Open',
            operator: RuntimeFilterOp.NOT_IN,
            values: ['Bot', 'Likely a Bot'],
          },
        ]

[
          {
            columnName: 'True Open',
            operator: RuntimeFilterOp.NOT_IN,
            values: ['Bot', 'Likely a Bot'],
          },
        ]

[
          {
            columnName: 'True Open',
            operator: RuntimeFilterOp.NOT_IN,
            values: ['Bot', 'Likely a Bot'],
          },
        ]

When we add a filter field inside the liveboard directly, though, it works.

N

Nikhil Kumaran S•10/8/24, 11:18 AM

Hi Team, we are facing this error message in our embed from time to time. Do we have a way to check what causes this? Idenity which request is failing or timing out?

N

Nikhil Kumaran S•10/8/24, 11:45 AM

Hi Team, while choosing source, can we have the option to select only single source? Basically have only single select instead of multiselect

M

Murali Krishna•10/8/24, 3:07 PM

Hey team, quick question.
we have one worksheet with 5 views joined. and we have 6 widgets coming from same worksheet.
What i was wondering is it possible to hide columns depending on widget?
For eg, 2 out of 5 are application data and file data. For one widget columns from these two only should show, now all columns from other 3 views are also showing. So if i can hide specific columns based on widget

P

Priyadarshi•10/8/24, 6:24 PM

Hey Team,
Can I integrate thoughspot in mobile apps using react native? If yes, How?

S

Suvash•10/9/24, 12:04 AM

Hey team, here after @Charlie Birch pointed to this channel. We are currently using the Visual SDK Basic Auth to test some POC. We are aware of the different types of auth available and know that this is not the best way to implement. Pretty new to the ThoughtSpot world and testing things around. For this thread, after the implementation we are getting some errors in the console even though the page is working fine. Could you help us figure out how to make sure we do not get that error message?
Clearing the console and visiting the next tab results in the same error message. The page will work fine though. @rumana-hf

N

Nikhil Kumaran S•10/9/24, 8:13 AM

Hi Team, can we customise the pre populated dashboard name?

Right now, from search, when we try to pin a chart, it creates a dashboard with this name {username}'s first Dashboard. Can we customise this name with a config?

J

Jean Mandarin•10/9/24, 8:41 PM

hi team
what is the API endpoint to get a list of all liveboards in my account, including their author, description, last modified and verfication status?

J

joel•10/10/24, 7:48 PM

Hi Team,

How can I format a link to an external location in an answer on Thoughtspot platform directly (not embedded). I was trying to get this basic formula working:

concat("{caption}","my link","{/caption}","google.com")

concat("{caption}","my link","{/caption}","google.com")

concat("{caption}","my link","{/caption}","google.com")

concat("{caption}","my link","{/caption}","google.com") which I expected to give me a link on "my link" to google.com. Instead it gives a link to "https://<thoughtspot-server>.cloud/google.com". Is there some setting I have to turn off somewhere to get my links to not be appended to the server url?

J

joel•10/12/24, 1:14 AM

Hi team,

What control do we have over the message displayed to the user when they trigger a URL action (https://developers.thoughtspot.com/docs/custom-action-url)? I know it displays the code and says successful/failed based on that. Is there anything else we can control? Does it use any fields in the response other than status code?

We have our own API that we are triggering with the URL action so we can control the response format and content.

Thank you!

F

Francis C•10/14/24, 7:00 PM

Hi Folks, We currently integrated (iframe) the dashboard and we would like to know if there an event / notification when the user fills up the create dashboard form? We would like to perform extra action when its submitted.

Screenshot_2024-10-14_at_11.50.25_AM.png

R

Raaghul Umapathy•10/15/24, 5:24 PM

Hi, Not sure why we are getting invalid auth token when we are attempting to get authtoken react init method for embedding liveboards

R

Raaghul Umapathy•10/15/24, 5:26 PM

R

Raaghul Umapathy•10/15/24, 5:27 PM

It is working only for me after deployment but not working for others. receiveing not logged in the UI.

B

Benedict•10/16/24, 12:09 PM

I have a quick question about the TSE and Actions. Currently, I'm using

disabledActions

disabledActions

disabledActions

disabledActions to turn off features. Would it make sense to switch to using

visibleActions

visibleActions

visibleActions

visibleActions instead so we can control new features being added? Or is that approach likely to be problematic

B

Benedict•10/16/24, 12:11 PM

ALSO, the Actions enum contains a bunch of

@hidden

@hidden

@hidden

@hidden values or ones without documentation. Are these deprecated ones that have no effect?

A

Alfredo•10/16/24, 6:06 PM

Hey team, it seems like the scrollbar doesn't work when the UI is small. Any idea how to fix that? In the video below, it works fine on a large screen, but when the screen is small, the scrollbar only shows a small portion of the actual liveboard.

J

Jessica•10/17/24, 5:28 PM

hi there, I have two issues where our font-weight in the customCSS isn't updating properly and our conditional css with the ~ selector isn't working. Any help is appreciated!

V

Vanilla Gorilla•10/17/24, 7:28 PM

Is there an API that allows me to create a new blank liveboard?

A

Adrian•10/21/24, 8:13 AM

Hi there,
I want to get liveboard filters using

HostEvent.GetFilters

HostEvent.GetFilters

HostEvent.GetFilters

HostEvent.GetFilters but I am getting following error:

Error: Trigger timedout in getting response
    at eval (processTrigger.ts:67:1)
This is the code I have:

Error: Trigger timedout in getting response
    at eval (processTrigger.ts:67:1)
This is the code I have:

Error: Trigger timedout in getting response
    at eval (processTrigger.ts:67:1)
This is the code I have:

Error: Trigger timedout in getting response
    at eval (processTrigger.ts:67:1)
This is the code I have:

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();
 
  const getFilters: MessageCallback = useCallback(() => {
    embedRef.current.trigger(HostEvent.GetFilters).then(console.log);
  }, []);
 
  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onLiveboardRendered={getFilters}
    />
  );
};

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();
 
  const getFilters: MessageCallback = useCallback(() => {
    embedRef.current.trigger(HostEvent.GetFilters).then(console.log);
  }, []);
 
  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onLiveboardRendered={getFilters}
    />
  );
};

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();
 
  const getFilters: MessageCallback = useCallback(() => {
    embedRef.current.trigger(HostEvent.GetFilters).then(console.log);
  }, []);
 
  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onLiveboardRendered={getFilters}
    />
  );
};

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();
 
  const getFilters: MessageCallback = useCallback(() => {
    embedRef.current.trigger(HostEvent.GetFilters).then(console.log);
  }, []);
 
  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onLiveboardRendered={getFilters}
    />
  );
};

I also checked other

HostEvents

HostEvents

HostEvents

HostEvents and I am getting the same error.

N

Nikhil Kumaran S•10/21/24, 3:25 PM

Hi team, in most cases we have userIds in the thoughtspot system. In the embed, is there a way to call an API(our backend API) to get the user name before displaying here in the table embed?

A

Adrian•10/23/24, 2:39 PM

Hi there,

I need liveboard data after I change the filers. I am trying to fetch the liveboard data using REST API v2 (

api/rest/2.0/metadata/liveboard/data

api/rest/2.0/metadata/liveboard/data

api/rest/2.0/metadata/liveboard/data

api/rest/2.0/metadata/liveboard/data). I call the API in

onFilterChanged

onFilterChanged

onFilterChanged

onFilterChanged callback.

The request is send on every filter change but I always receive the original data (no filters applied).
In the docs you use

createFormDataObjectWith

createFormDataObjectWith

createFormDataObjectWith

createFormDataObjectWith to build the request

body

body

body

body
Could you please let me what this function should do? What body should I pass?

In the same doscs you say to pass the

transient_pinboard_content

transient_pinboard_content

transient_pinboard_content

transient_pinboard_content and than in the example you use

transient_content

transient_content

transient_content

transient_content. Which one is correct?

This is the code I have:

import {
  HostEvent,
  LiveboardEmbed,
  MessageCallback,
  useEmbedRef,
} from '@thoughtspot/visual-embed-sdk/react';

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();

  const handleFilterChanged: MessageCallback = () => {
    embedRef.current
      .trigger(HostEvent.getExportRequestForCurrentPinboard)
      .then(transientPinboardContent => {
        fetch(
          `${HOST}/api/rest/2.0/metadata/liveboard/data?metadata_identifier=${ID}`,
          {
            method: 'POST',
            credentials: 'include',
            body: JSON.stringify({
              transient_content: transientPinboardContent,
            }),
          },
        )
          .then(response => response.json())
          .then(console.log)
          .catch(console.log);
      });
  };

  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onFilterChanged={handleFilterChanged}
    />
  );
};

import {
  HostEvent,
  LiveboardEmbed,
  MessageCallback,
  useEmbedRef,
} from '@thoughtspot/visual-embed-sdk/react';

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();

  const handleFilterChanged: MessageCallback = () => {
    embedRef.current
      .trigger(HostEvent.getExportRequestForCurrentPinboard)
      .then(transientPinboardContent => {
        fetch(
          `${HOST}/api/rest/2.0/metadata/liveboard/data?metadata_identifier=${ID}`,
          {
            method: 'POST',
            credentials: 'include',
            body: JSON.stringify({
              transient_content: transientPinboardContent,
            }),
          },
        )
          .then(response => response.json())
          .then(console.log)
          .catch(console.log);
      });
  };

  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onFilterChanged={handleFilterChanged}
    />
  );
};

import {
  HostEvent,
  LiveboardEmbed,
  MessageCallback,
  useEmbedRef,
} from '@thoughtspot/visual-embed-sdk/react';

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();

  const handleFilterChanged: MessageCallback = () => {
    embedRef.current
      .trigger(HostEvent.getExportRequestForCurrentPinboard)
      .then(transientPinboardContent => {
        fetch(
          `${HOST}/api/rest/2.0/metadata/liveboard/data?metadata_identifier=${ID}`,
          {
            method: 'POST',
            credentials: 'include',
            body: JSON.stringify({
              transient_content: transientPinboardContent,
            }),
          },
        )
          .then(response => response.json())
          .then(console.log)
          .catch(console.log);
      });
  };

  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onFilterChanged={handleFilterChanged}
    />
  );
};

import {
  HostEvent,
  LiveboardEmbed,
  MessageCallback,
  useEmbedRef,
} from '@thoughtspot/visual-embed-sdk/react';

const Liveboard = () => {
  const embedRef = useEmbedRef<typeof LiveboardEmbed>();

  const handleFilterChanged: MessageCallback = () => {
    embedRef.current
      .trigger(HostEvent.getExportRequestForCurrentPinboard)
      .then(transientPinboardContent => {
        fetch(
          `${HOST}/api/rest/2.0/metadata/liveboard/data?metadata_identifier=${ID}`,
          {
            method: 'POST',
            credentials: 'include',
            body: JSON.stringify({
              transient_content: transientPinboardContent,
            }),
          },
        )
          .then(response => response.json())
          .then(console.log)
          .catch(console.log);
      });
  };

  return (
    <LiveboardEmbed
      ref={embedRef}
      liveboardId={ID}
      onFilterChanged={handleFilterChanged}
    />
  );
};

Data and Report APIs

J

Jessica•10/24/24, 7:25 PM

Hi there! I'm curious if it's possible to extend the overrlay (ReactModalOverlay ReactModalOverlay--after-open) to beyond the iframe?

J

Jessica•10/24/24, 8:59 PM

Hi there! I'm having issues with the customization strings: "Anyone who already has access to this Liveboard can use this link to view the Liveboard" & "This Liveboard is not discoverable"

M

Mohsin Manzoor Bhat•10/25/24, 7:21 AM

Hi , Can anyone please let me know if there is a way to disable that explore option for a newly logged in user and second that when an admin shares dashboard he is having 2 options to share 1, Can View and 2. Can edit. Is there a way in SDK or from ThoughtSpot UI that we can restrict that Can Edit, so that all sharable dashboard should be view only by default ?

F

Farzaneh•10/25/24, 7:32 PM

Hi, we are using TS embedded in our application, and we're facing issues with updating filters programmatically after the liveboard has loaded. We utilize

HostEvent.UpdateFilters

HostEvent.UpdateFilters

HostEvent.UpdateFilters

HostEvent.UpdateFilters for this purpose, but the problem is that triggering it on the

EmbedEvent.LiveboardRendered

EmbedEvent.LiveboardRendered

EmbedEvent.LiveboardRendered

EmbedEvent.LiveboardRendered event doesn’t update the liveboard because the charts aren’t completely loaded yet. Consequently, we have resorted to using

setTimeout

setTimeout

setTimeout

setTimeout to delay the UpdateFilters process, which is not an ideal solution. The time needed for the timeout varies and can lead to errors in some cases (Please check the code snippet below).

I’m wondering if there’s an event that indicates when the liveboard, including all charts and contents, is fully loaded. Alternatively, are there any other solutions to address this issue?

embed.on(EmbedEvent.LiveboardRendered, () => {
    setTimeout(() => {
        embed.trigger(HostEvent.UpdateFilters, {
            filter: {
                column: "Currency",
                oper: "EQ",
                values: [window.defaultCurrency]
            }
        })
    }, 500);
});

embed.on(EmbedEvent.LiveboardRendered, () => {
    setTimeout(() => {
        embed.trigger(HostEvent.UpdateFilters, {
            filter: {
                column: "Currency",
                oper: "EQ",
                values: [window.defaultCurrency]
            }
        })
    }, 500);
});

embed.on(EmbedEvent.LiveboardRendered, () => {
    setTimeout(() => {
        embed.trigger(HostEvent.UpdateFilters, {
            filter: {
                column: "Currency",
                oper: "EQ",
                values: [window.defaultCurrency]
            }
        })
    }, 500);
});

embed.on(EmbedEvent.LiveboardRendered, () => {
    setTimeout(() => {
        embed.trigger(HostEvent.UpdateFilters, {
            filter: {
                column: "Currency",
                oper: "EQ",
                values: [window.defaultCurrency]
            }
        })
    }, 500);
});

F

FenixShadow20•10/28/24, 2:53 PM

Hi, we have 2 types of data that can be shown for a particular measure in a liveboard, one of which is percentage data and the other is numeric. We have a filter on the liveboard to select one or the other since it doesn't make sense to aggregate them together (each data row has a column that indicates which type of data it is, and we filter on that). However, when the percentage option is selected, we want to show a percentage sign after the number, but not when the numeric option is selected. I tried setting this up in a formula by concatenating the percent sign but this changes the value to a string instead of a number, which doesn't work for aggregating values.

Is there any way this can be achieved?

J

Jessica•10/28/24, 6:35 PM

hi there! we're trying to intercept the sharing of a liveboard, however I can't seem to:
1. prevent notifications, even when I tried adding (this prevented the nofitication when it was selected but not when it wasn't selected):
embed.trigger(HostEvent.Share, {
notify: false
})
2. determine which name or email address of the user or group name was entered in the share modal

R

Regan•10/29/24, 12:01 PM

Hey, we are making 2 requests after initing the visual embed SDK. One to get the Id of a tagged liveboard and one to get the Id of a tagged worksheet. We are using 2 separate tokenizedFetch requests to do this but the request for the worksheet just brings back the data for the liveboard. We are specifying the type as 'LIVEBOARD' with the tag for the liveboard request and specifying the type as 'LOGICAL_TABLE' with the tag for the worksheet. The tags are also different for the liveboard and worksheet. Does anyone if this is something to do with how tokenizedFetch works?

RRegan Hey, we are making 2 requests after initing the visual embed SDK. One to get the...

R

Regan•10/29/24, 12:02 PM

Ive also managed to copy and execute the worksheet request in postman and it returns the correct data, just not when using tokenizedFetch

P

Phule of a Took•10/29/24, 8:11 PM

When I update a user email via the API the user receives an email from Okta about the change. Is there a way to prevent these emails from going out?

None of our users know who Okta is, nor that it is being used in the background. Since we are looking at embedding most will not even know who ThoughtSpot is.

(Also asked in the community)

L

Leslie Chiang•10/31/24, 5:09 PM

We seem to be running into an issue where TS occasionally fails to respect filter parameters in

metadata/search

metadata/search

metadata/search

metadata/search - it's returning many more results than what would be expected (we are filtering on favorites for a given user). The problematic request/response is the second one in the HAR file.

N

nydamon•11/1/24, 3:19 PM

hello TS Support! I am having a problem with runtime filters in an embedded liveboard. Also i have a question regarding applying runtime filters conditionally to a specific answer.

Would you mind looking at this and giving me advice?
https://www.loom.com/share/c2ab8fc0ae8243c59849a1a48d755dc0

Loom

Live Board Embed Testing

Hi, in this video, I'm testing a live board embed feature with a focus on the AFFID parameter set to 3279. I demonstrate how the AFFID column interacts with the formula and address conflicts by showcasing the equal values. I request viewers to observe why the formula doesn't apply in this scenario.

J

Jessica•11/4/24, 3:04 PM

hi there! is there a way to set a description for the SpotIQ page in the embed?

G

gabe_f•11/5/24, 6:16 PM

Hello, we currently are getting "Could not reach server. Try again later." when either internal or external customer's are trying to log-in. Assuming this is a wide spread issue, but just want to confirm it's not limited to just our server. Thanks.

B

BenJones•11/5/24, 8:41 PM

Hey y'all! Does anyone know if the

exportAnswerReport

exportAnswerReport

exportAnswerReport

exportAnswerReport call works on the Typescript API? The return type is

void

void

void

void which does not seem to make sense: https://github.com/thoughtspot/rest-api-sdk/blob/release/sdks/typescript/apis/ReportsApi.ts#L131

I keep getting `Failed to commit. Status code: 500`

Similar Threads

Similar Threads

Similar Threads