Adding Caluclated fields to view via webservices or rest api

nitin.lakhwani shared this idea 10 months ago
Idea Logged

Hi,

i wanted to add calculated fields to the view via webservices or rest api and wanted to know if it is possible currently and if not can we add it to the feature list for upcoming release

--

Nitin

Comments (9)

photo
0

Hey Nitin,

Thanks for reaching out with this.

Looking through our API I wasn't able to immediately find a method to add calculated fields to the a view using webservices. I am reaching out to my team to see if this is possible.

Once I have an update on whether this is currently possible I will be sure to provide that to you here!

Best,

Jared

photo
0

Hey Nitin,

I wanted to reach out and let you know where I've been able to get with this.

We may be able to leverage something like our METADATASQLQUERY from our SOAP API https://wiki.yellowfinbi.com/display/yfcurrent/Web+Services+Directory

This would allow us to run any query against your configuration database. With this said, we will want to be sure that backups are made of the configuration during or before these processes, as if it becomes corrupt we wont want to lose a bunch of progress made altering the views in this way having to revert to an older backup.

Outside of this I am unsure how we can alter the view in this manner and may have to reach out to our devs to see if they might have further insight on this!

Best,

Jared

photo
0

Hi Nitin,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Best,

Jared

photo
0

Hi Jared,

I haven't been able to try METADATASQLQUERY via webservices yet , will give it a shot this weekend and keep you posted in case i face any issue . apologies for late reply.

photo
0

No worries on a late reply!

Let me know if this works for our use case here once you are able to test it.

Thanks,

Jared

photo
0

Hi Jared,

I went ahead and tried giving METADATASQLQUERY a shot , But i wasnt able to create a calculated field in a view with it. also since we need to use this feature on regular basis on various cleint orgs there is a high chance that some might go wrong .

so , i think if we can add this feature to ADDCOLUMNTOVIEW of view management to webservices or rest api that will do the trick.

for now i have put the feature that needs this webservice on our end on hold.

photo
0

Hey Nitin,

Thanks for the update on this.

I am reviewing this further to see if there are any methods known to our teams to accomplish this use case.

Once I've been able to discern the possibility of doing this I will be sure to let you know promptly!

Best,

Jared

photo
1

Hi Nitin,

I have confirmed there is no possible way to create a calc field via web services so have converted this to a product feature request on your behalf (a public idea post). While we don't have immediate plans to address this right now, I can ensure you are kept in the loop on any updates via this topic.


As for possible workarounds, you could look at creating calc fields and then automating an export/import via WS, this may or may not be easier for you, just thought it was worth mentioning.


Please let me know if there was anything else you were after in the meantime.


Regards,

David

photo
1

David,

Thanks for converting it to a product feature request.

 also appreciate the idea for workaround using import export the issue here is that each field will have slightly different parameters to be passed to a mysql function.

On Mon, Nov 8, 2021 at 9:33 AM Yellowfin Support <support@yellowfin.bi> wrote:

photo
1

No problems. Yeah it's an idea, not necessarily feasible for your use-case :( . Just trying to think outside the box.

Thanks for understanding in any case!

photo