mixing jinja with to_json pipe

Question

Hi all&nbsp;I'm trying to get the following json object to be assembled during a pipeline:{{{&nbsp; &nbsp;"service":"CreateOrder",&nbsp; &nbsp;"site_Acc_id":"gausolar",&nbsp; &nbsp;"order_source":"GoSolr Test",&nbsp; &nbsp;"fname":a.name,&nbsp; &nbsp;"lname":a.surname,&nbsp; &nbsp;"email":a.email,&nbsp; &nbsp;"mobile":a.mobile_number,&nbsp; &nbsp;"wnumber":a.mobile_number,&nbsp; &nbsp;"email":a.email,&nbsp; &nbsp;"unit_id":"",&nbsp; &nbsp;"street_num":"",&nbsp; &nbsp;"street_name":a.premise_address,&nbsp; &nbsp;"region":a.area_of_install,&nbsp; &nbsp;"city":"",&nbsp; &nbsp;"suburb":"",&nbsp; &nbsp;"service_array":[&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"supplier_sku":a.system_size_sku,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"roof_type":a.roof_type,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"flat_roof":a.is_flat_roof&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp;],&nbsp; &nbsp;"instl_address":a.premise_address,&nbsp; &nbsp;"postalcode":"",&nbsp; &nbsp;"promocode":"",&nbsp; &nbsp;"sales_stage":"To Be Scheduled",&nbsp; &nbsp;"teamid":0,&nbsp; &nbsp;"coc_certificate":"No",&nbsp; &nbsp;"inst_start_date_time":"",&nbsp; &nbsp;"inst_end_date_time":"",&nbsp; &nbsp;"completion_date1":"",&nbsp; &nbsp;"inst_turnaround":"",&nbsp; &nbsp;"order_no":a.order,&nbsp; &nbsp;"order_size":a.system_size_sku,&nbsp; &nbsp;"prepaid_postpaid": a.prepaid_meter,&nbsp; &nbsp;"elec_provider":a.electricity_provider,&nbsp; &nbsp;"roof_type":a.roof_type,&nbsp; &nbsp;"comment_1":a.scheduling_comment,&nbsp; &nbsp;"inst_size":"",&nbsp; &nbsp;"income":"",&nbsp; &nbsp;"upgrade":"",&nbsp; &nbsp;"panels":"",&nbsp; &nbsp;"battery":"No",&nbsp; &nbsp;"flat_roof":"",&nbsp; &nbsp;"extra":"",&nbsp; &nbsp;"expense":"",&nbsp; &nbsp;"profit":"",&nbsp; &nbsp;"o_m_fee":"65.00",&nbsp; &nbsp;"xtra_battery":"",&nbsp; &nbsp;"has_flat_roof":a.is_flat_roof,&nbsp; &nbsp;"own_or_rent":"",&nbsp; &nbsp;"meter_type":"",&nbsp; &nbsp;"mnth_elec_bill":"",&nbsp; &nbsp;"elec_phases":{% if a.electricity_phase == "Single" %}&nbsp; "Single Phase"{% elif a.electricity_phase == "Three" %}&nbsp; "Three Phase"{% else %}&nbsp; "I Dont Know"{% endif %} ,&nbsp; &nbsp;"owner_insurance":"",&nbsp; &nbsp;"dwelling_type":"",&nbsp; &nbsp;"gosolr_pass":""}|to_json}}As you can see I'm piping the whole&nbsp; object to_json at the end, sadly this is causing the jinja&nbsp; if statements to give issues. Looks like you can't blanket parse the whole object if there are jinja statements in between.&nbsp;The main issue is, if I to_json each field independently, then the payload doesn't format correctly and the end point API rejects the call. How to I still use to_json at the end while still allowing jinja if statements&nbsp;in between?------------------------------James van der Walt------------------------------

dwightmunson1 · Answer

Could you set it as a variable and then send it to JSON at the end? I did something similar before.&nbsp;

{% set jsonPayload = {&nbsp; "service": "CreateOrder",&nbsp; "site_Acc_id": "gausolar",&nbsp; "order_source": "GoSolr Test",&nbsp; "fname": "{{ a.name }}",&nbsp; "lname": "{{ a.surname }}",&nbsp; "email": "{{ a.email }}",&nbsp; "mobile": "{{ a.mobile_number }}",&nbsp; "wnumber": "{{ a.mobile_number }}",&nbsp; "email": "{{ a.email }}",&nbsp; "unit_id": "",&nbsp; "street_num": "",&nbsp; "street_name": "{{ a.premise_address }}",&nbsp; "region": "{{ a.area_of_install }}",&nbsp; "city": "",&nbsp; "suburb": "",&nbsp; "service_array": [&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; "supplier_sku": "{{ a.system_size_sku }}",&nbsp; &nbsp; &nbsp; "roof_type": "{{ a.roof_type }}",&nbsp; &nbsp; &nbsp; "flat_roof": "{{ a.is_flat_roof }}"&nbsp; &nbsp; }&nbsp; ],&nbsp; "instl_address": "{{ a.premise_address }}",&nbsp; "postalcode": "",&nbsp; "promocode": "",&nbsp; "sales_stage": "To Be Scheduled",&nbsp; "teamid": 0,&nbsp; "coc_certificate": "No",&nbsp; "inst_start_date_time": "",&nbsp; "inst_end_date_time": "",&nbsp; "completion_date1": "",&nbsp; "inst_turnaround": "",&nbsp; "order_no": "{{ a.order }}",&nbsp; "order_size": "{{ a.system_size_sku }}",&nbsp; "prepaid_postpaid": "{{ a.prepaid_meter }}",&nbsp; "elec_provider": "{{ a.electricity_provider }}",&nbsp; "roof_type": "{{ a.roof_type }}",&nbsp; "comment_1": "{{ a.scheduling_comment }}",&nbsp; "inst_size": "",&nbsp; "income": "",&nbsp; "upgrade": "",&nbsp; "panels": "",&nbsp; "battery": "No",&nbsp; "flat_roof": "",&nbsp; "extra": "",&nbsp; "expense": "",&nbsp; "profit": "",&nbsp; "o_m_fee": "65.00",&nbsp; "xtra_battery": "",&nbsp; "has_flat_roof": "{{ a.is_flat_roof }}",&nbsp; "own_or_rent": "",&nbsp; "meter_type": "",&nbsp; "mnth_elec_bill": "",&nbsp; "elec_phases": "{% if a.electricity_phase == 'Single' %}Single Phase{% elif a.electricity_phase == 'Three' %}Three Phase{% else %}I Dont Know{% endif %}",&nbsp; "owner_insurance": "",&nbsp; "dwelling_type": "",&nbsp; "gosolr_pass": ""} %}
{{ jsonPayload|to_json }}------------------------------Dwight Munson------------------------------

jamesvan_der_wa · Answer

Thanks for the quick reply Dwight,&nbsp;Sadly the solution didn't work. First, I see you put quotations around all the variables. If I do that then all of these are just strings in the final output.Second, If I remove the quotation then the body section of the "Make Request" doesn't validate.&nbsp; &nbsp;------------------------------James van der Walt------------------------------

dwightmunson1 · Answer

Maybe it has to do with the white space around the jinja expressions? I should have taken that out.&nbsp;
This is what I do with mine, in which I query records in a work request table to find work to charge project management time to. That data is the b.json.data. Then I use this step to loop through the data and create time cards up to the time in a.hours.
Make a request step:Method: POST
Content Type: Application/jsonBody:&nbsp;
{
{% set myDataSet = "myDBID" %}
{% set myTimeStop = namespace(val=a.hours) %}
{% set runningTotal = namespace(val=0.0) %}
{% set relatedTimeSheet = namespace(val=a.related_time_sheet) %}
{% set relatedWorkCode = namespace(val=a.related_work_code) %}
{% set relatedClass = namespace(val=a.related_class) %}
&nbsp;
"to": "{{myDataSet}}",
"data":[
&nbsp; &nbsp; {% for row in (b.json.data) if runningTotal.val &lt; myTimeStop.val %}
&nbsp; &nbsp; &nbsp; &nbsp; {% set remainingTime = myTimeStop.val - runningTotal.val %}
&nbsp; &nbsp; &nbsp; &nbsp; {% set currentValue = row['33'].value if row['33'].value &lt;= remainingTime else remainingTime %}
&nbsp; &nbsp; &nbsp; &nbsp; {% set runningTotal.val = runningTotal.val + currentValue %}
&nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "37":{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{row['36'].value | int}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "39":{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{row['8'].value | int}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "28":{
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{relatedWorkCode.val | int}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "42":{
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{relatedClass.val | int}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "655":{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{row['13'].value | int}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "227":{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{currentValue}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "34":{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "{{relatedTimeSheet.val | int}}"
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; {% if loop.last == false and runningTotal.val &lt;= myTimeStop.val %},{% endif %}
&nbsp; &nbsp; {% endfor %}
]
}------------------------------Dwight Munson------------------------------

Forum Discussion

mixing jinja with to_json pipe

Related Content

Pipeline Jinja For Duration in Seconds

Jinja If statement equals field value

Performing Multiplication in Jinja for Pipelines

Jinja Question: Adding business days to today

Jinja Expression Comparing Now to Now+Hours