JSON Renders in JSFiddle but Fails in Flexmonster Native

Hi Mykhailo,
 
No problem -- we are looking to use Flexmonster for our systems so maybe it makes sense to chat in person. Please email me at kkanagal@bamfunds.com and we can coordinate a time to discuss further and price out the full version as well.
 
Thanks,
Kapil

Hi Mykhailo,
 
I am working in native JS and I believe I have set up all the columns in my report correctly for my Flexmonster object; however, when I render the page, it only displays 1 column. I am refreshing the data on an interval using this example. How can I get all my columns to render and display them in the order I have outlined in my report variable on load? Currently, I need to click on the arrow in the top right corner and select all the fields to display.
Thanks!
-Kapil

async function webRequest() {
  let url = "portfolios/CFIN_BOT";
  // await sleep(15000);
  let response = await fetch(url, { method: 'GET'})
  return response;
}

function updateData(data_passed) {
  pivot.updateData({
    data: JSON.parse(data_passed)
  })
}

var report = {
      dataSource: {
        type: "json",
      },
      "slice": {
        "rows": [{
            "uniqueName": "symbol"
          },
          {
            "uniqueName": "UL"
          },
          {
            "uniqueName": "Expiry"
          }
        ],
        "columns": [{
          "uniqueName": "[Measures]"
        }],
        "measures": [
          {
            "uniqueName": "Qty",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Net PnL",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Cumul Pnl",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Trade PnL",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "price",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "delta",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "gamma",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Dollar Delta",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Dollar Gamma",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "vega",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Weighted Vega",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "VIX Vega",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "theta",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "vanna",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "volga",
            "active": true,
            "aggregation": "sum"
          },
          {
            "uniqueName": "Vol",
            "active": true,
            "aggregation": "average"
          },
          {
            "uniqueName": "YDay Vol",
            "active": true,
            "aggregation": "average"
          }
        ]
      },
      "formats": [{
      "name": "rate_format",
      "decimalPlaces": 4
    }]
  };


var pivot = new Flexmonster({
    container: "#pivot-container",
    componentFolder: "https://cdn.flexmonster.com/",
    width: "100%",
    height: 1000,
    report: report,
    reportcomplete: function() {
      pivot.off("reportcomplete");
      setInterval(
        function() {
          blarg()
        },
        60000
      );
    }
});

function blarg(){
  return webRequest().then((resp) => resp.json()).then((idkIveLostMyWillToLive) => updateData(idkIveLostMyWillToLive))
}

Hi Mykhailo,
 
Doing well thanks! Hope you had a very happy Halloween. This worked in terms of resolving the issue for our problem. More broadly, is there a feature in flexmonster to group rows and create subheadings within the table?
 
Thanks,
Kapil

Hi Mykhailo,
 
Wanted to follow up with another question -- if I have a multiindex pandas dataframe, how can I convert it into the proper form and display as a hierarchical table in Flexmonster?
 
Thanks,
Kapil

Hey Mykhailo,
Thanks for all of your help with this -- someone from our back office should be reaching out to your team shortly for the full-time license! We are excited to continue using Flexmonster as a part of our workflow.
One question a member of our team had was if it would be possible to save down columns that are created from the "Add calculated value" button for future use or whenever they reload the page. Screenshot attached. Is there some parameter I can pass within the JS to do so?
Thanks for all of your help and look forward to speaking soon.
-Kapil