Issue with conga URL

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi I try use following conga url in skuid with some changes but getting error.
could you please help me to resolve the issue.

https://composer.congamerge.com/ 
?sessionId={!API.Session_ID} 
&serverUrl={!API.Partner_Server_URL_290} 
&id={!Opportunity.Id} 
&DC={!IF(Opportunity.Total_Offer_Value__c = 0 || ISPICKVAL( Opportunity.Offer_Template__c , "") || Opportunity.Data_Check__c = "Data Items Missing" , "1", "0") } 
&DCL=No+products+to+offer+or+"Offer+Type"+not+selected+or+No+Decision+or+Data+Items+Missing 
&TemplateID={!Opportunity.USA_Offer_Template_ID__c} 
&DS7={!IF($User.Create_Word_Offers__c = true, 0, 2)} 
&DS4=1 
&DS3=1 
&LG1=Offer Letter 
&LG0=1 
&OFN={!Opportunity.Account}+-+Offer+Letter+{!IF( Opportunity.Sponsor_Name__c = "", "", "Sponsored")} 
&LG3=1 
&LG4=1 
&ReportId=00O300000059mmr,00O300000059mms,00O300000059mmo,00O300000059mmq,00O300000059mmp,00O300000059s6T,00O300000059zbL,00O300000067IAi,00O300000067IBH,00O300000067IGN,00O300000084Jlq,00O300000085knf,00O30000008uuyZ,00O30000008uuye,00O30000008uuyj,00O30000008uuyo,00O30000008uuyt,00O30000008uuyy,00O30000008uwgI,00O30000008uwgD
&Queryid=a1p30000000cCPF 
&EmailRelatedToId={!Opportunity.Id} 
&EmailTemplateId={!CASE(Opportunity.Centre_MIS_Code__c, "CSU", "00X30000001jE9k", "MAR", "00X30000001jEAs", "SLU", "00X30000001jusl", "OSU", "00X30000001jEC0", "USF", "00X30000001jEDS", "NYD", "00X30000001jV8I","GMU", "00X30000001jV6G","UAB", "00X30000002K53N", "")} 
&DefaultPDF=1 
&EmailFromId={!Opportunity.From_Email_Address__c} 
&ZipPDFs=0 
&EmailTemplateAttachments=1 
&EmailCC={!Opportunity.GroupCcAddress__c} 
&UF0=1 
&mfts0=Offer_Letter_Sent__c 
&mftsvalue0=TRUE 
&MFTS1=USA_Date_Time_Latest_Offer_Letter_Sent__c 
&MFTSValue1=NOW


Thanks
Deleep
Photo of Deleep Manda

Deleep Manda

  • 246 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Skuid does not use the standard VF merge syntax.  So the statement: " ?sessionId={!API.Session_ID} " will actually not return any data when run within Skuid.  You need to look into the syntax skuid uses.  Here is an instruction document:  
http://help.skuid.com/m/11720/l/216661-skuid-template-syntax

Information on global functions (like API.Session_ID and urlEncoding) are found here:  http://help.skuid.com/m/11720/l/187263-global-merge-variables-functions

I'm also pretty sure that the CASE statement in the url will also fail.  You may have to build a UI Only field in the model, or a formula field that creates this value that is then passed into the URL. 
The more striaghtforward conditional statements should be possible using Skuid syntax.  The method for doing that is shown in the first link. 

Good luck!