How to pass a URL with column name having '/'

[Sreya]

I am having a coulmn name 'ContractKey/EngagementKey'. How to Pass this column in URL. Below Filter is not working because of the column name as it contains '/'.

?filter=Project/ContractKey/EngagementKey in ('791751','791824','1025638')

How to solve this issue?

[v-shex-msft · Accepted solution]

HI @Sreya,

I'd like to suggest you take a look at the official document specific characters to handle part if they helped:

Filter a report using query string parameters in the URL#special-characters-in-url-filters 

If these not help, you can add a calculated column to your table with a common name. (copy the value from 'specific characters' column and use this to replace the raw field in URL filter)
Regards,

Xiaoxin Sheng

[amitchandak]

@Sreya , not very clear to me. Base on what I got is that you need dynamic url

refer, if this can help

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

[Sreya]

@amitchandak I am having a column name 'ContractKey/EngagementKey'. While I try to pass filter on this column the target report is not getting filtered. It is happenning because the column name contains '/ ' in it.

Anyway we can solve this by using escape character or something like that?

[amitchandak]

@Sreya , Try

/

%2F

refer :https://www.december.com/html/spec/esccodes.html

[Sreya]

@amitchandak No luck

Previous generated URL

filter=Project%2FContractKey%2FEngagementKey%20in%20(%27791751%27,%27791824%27,%271025638%27)

After appending %2F ---Newly Generated URL

filter=Project%2FContractKey%2F%2FEngagementKey%20in%20(%27791751%27,%27791824%27,%271025638%27)

It is not passing the column name as 'ContractKey/EngagementKey'