How to change or get the URL length of more than 2000 characters? ACC Work flow javascript code

[GauravPK]

I want to change the length of my string type URL field to 2048 i.e.  <attribute label="Links Url" length="2048" name="lnksUrl" type="string"/>  but its not working. Its only working when the length is of 1024. Any idea on how we can manage to extract.

Do i need to take any other data type instead of string?

In my code I have written as

* In Schema - 

  <attribute label="Links Url" length="2048" name="lnksUrl" type="string"/>

* In Workflow Javascript -

  var linksURL = jsonObj.content[index].links.url;

* And asigning it to the schema

  lnksUrl ={linksURL}

Any idea ? 

But not working.

[Jonathon_wodnicki · Accepted solution]

Hi,

What is not working? Does memo work instead of string?

Thanks,

-Jon

[GauravPK]

We are fetching JSON data in a var type. Then we are assigning the var value to <attribute label="Links Url" length="2048" name="lnksUrl" type="string"/>.schema. Problem is when that when I change the length of my string type URL field to 2048 i.e.  <attribute label="Links Url" length="2048" name="lnksUrl" type="string"/>  but its not working. Its only working when the length is of 1024. Any idea on how we can manage to extract.

Do i need to take any other data type instead of string?

[Jonathon_wodnicki]

Alternative data type is memo, though 2048 will fit in varchar for all of Campaign's supported db's. Did you run 'update database' after making the change?

[GauravPK]

Its working fine. Thanks

[jims52473243]

What was the solution? We are facing a similar problem.

Thanks,

Jim