How to pass javascript variable into liquid fetch in portal ?

[huuhung]

Hi everyone !

I have a problem.

How to pass javascript variable into liquid fetch in portal ?

Please help !

Thanks !

[huuhung]

I have received information from you. I am testing and will report back the results soon.
Thank you very much!

[huuhung]

Hi @chleverenz 

I followed your instructions and got the error message as shown below.

Please help !

Thanks !

[chleverenz]

Hi @huuhung ,

first of all: looks great, obviously this starts working for you. Congrats for that step.

In the jsonoutput you can see the stange sign json fails on (just go to the 31st position in the response, the errormessage is usually true). You have to be very careful in the jsongeneration really to producre correct json. So, may be removing tabs and strange spacecharacters in the liquidcode cause this problem.

I usually look in the answer from the service with the network tools built in in chrome. You could really see the response and put the response in an json capable editor (notepad++ with extension for example) and look, whether the json is ok.

But again: look in the template for unwanted characters. this seems to be the cause.

Sometimes, i have to substutute strange characters in the output, too, so considering adding a filter like | replace: "X" "U" to get rid of unwanted "X" in output might be helpful, too

Does this help?

Have fun,

  Christian

[huuhung]

Hi @chleverenz 

Code of the webPage "getPhaseWP" to get JSON

[chleverenz]

Hi @huuhung ,

i would move the fetchxml outside the squared brackets directly under the assigment and remove the blanks before the {% for... statement. And no newlines (i think this is the issue) in the liquid for jsongeneration. As far as i know, newlines always cause issues in json (my experience). Consider also ussing {%- instead of [% , bevause this prevents liwuid from generating newlines as well.

Hope it helps,

  Christian

[huuhung]

Hi @chleverenz !

I still not work !

Please help !

[chleverenz]

Hi @huuhung ,

unfortunately, you killed the squared brackets ( [ ] around all objects) 🙂  - happens 🙂

I personally (but is my be no issue) prefer not to have linebreaks in the json itself. Therefor, i usually have the curly brackets (opening and closing) on the same line as the output

Kind regards,

  Christian

[huuhung]

Hi @chleverenz 

It's not work !

error : Uncaught (in promise) SyntaxError: Unexpected token L in JSON at position 3

{%- assign test = request.params["proj"]  -%}
    {%- fetchxml my_query -%}
            <fetch mapping="logical" output-format="xml-platform" version="1.0" distinct="false" >
              <entity name="bsd_phaseslaunch" >
                <attribute name="bsd_phaseslaunchid" />
                <attribute name="bsd_name" />
                <attribute name="createdon" />
                <order attribute="bsd_launchedon" descending="true" />
                <filter type="and" >
                  <condition attribute="bsd_projectid" operator="eq" value="{{test}}" />
                  <condition value="100000000" attribute="statuscode" operator="eq" />
                </filter>
              </entity>
            </fetch>
      {%- endfetchxml -%}
[
{%- for phase in my_query.results.entities -%}
{"PhaseID":"{{phase.bsd_phaseslaunchid}}","Name":"{{phase.bsd_name}}"}
{%- unless forloop.last -%},{%- endunless -%}
{%- endfor -%}
]

[huuhung]

Hi @chleverenz !

I think my Json is missing double quote
How to show double quote in json !

[chleverenz]

Hi @huuhung ,

true. Did it work with the quoted hashkeys? JSON definition says, the keys have to be in quotes, somtimes the jason parsers also accept unquoted keys.

But i usually quote them for standard sake 🙂

Cheers,

  Christian