Discussions

  • 1.  JSON in Pipelines

    Posted 27 days ago
    Trying to build a pipeline to extract data from a 3rd party application.  Data connection functions without issue and am able to see the data coming into quickbase pipeline.  However, the manipulation of the data is not occurring.  Even after iterating the JSON object, the data is still passing blanks down to the quickbase steps within pipeline.  Any assistance is greatly appreciated.  Export of the pipeline is below:  

    # Workfront Data Pipeline
    #

    # Account slugs:
    # - quickbase[5RnE6yP]: IT Release Management <None>
    ---
    - META:
    name: Workfront Data Pipeline
    - ACTION json-handler json_source fetch_json_blob -> a:
    json_url: xxxxxxxxxxx@bmcjax.com&password=xxxxxxxxxxx&fields=referenceNumber,description,actualCompletionDate,actualDurationMinutes,actualStartDate,allApprovedHours,allUnapprovedHours,projectedCompletionDate,projectedStartDate,status,priority,approvalCompletionDate,approvalEstStartDate,approvalPlannedStartDate,approvalProjectedStartDate,approvalStartDate,budget,actualCost,actualExpenseCost,actualLaborCost,actualRevenue,budgetStatus,entryDate,estCompletionDate,estStartDate,work,workRequired,workRequiredExpression,plannedCompletionDate,plannedCost,plannedExpenseCost,plannedStartDate,ownerID">https://bmcjax.my.workfront.com/attask/api/v9.0/project/search?username=xxxxxxxxxxx@bmcjax.com&password=xxxxxxxxxxx&fields=referenceNumber,description,actualCompletionDate,actualDurationMinutes,actualStartDate,allApprovedHours,allUnapprovedHours,projectedCompletionDate,projectedStartDate,status,priority,approvalCompletionDate,approvalEstStartDate,approvalPlannedStartDate,approvalProjectedStartDate,approvalStartDate,budget,actualCost,actualExpenseCost,actualLaborCost,actualRevenue,budgetStatus,entryDate,estCompletionDate,estStartDate,work,workRequired,workRequiredExpression,plannedCompletionDate,plannedCost,plannedExpenseCost,plannedStartDate,ownerID
    ___: ___
    - a<>QUERY json-handler json_object search -> b:
    json_schema_sample: '{

    "referenceNumber":{

    "value" : 123456

    },

    "name":{

    "value" : "Test"

    },

    "description":{

    "value" : "Test"

    },

    "plannedStartDate":{

    "value" : "Test"

    },

    "plannedCompletionDate":{

    "value" : "Test"

    },

    "priority":{

    "value" : "Test"

    },

    "status":{

    "value" : "Test"

    },

    "ownerID":{

    "value" : "Test"

    }

    }'
    ___: ___
    limit: 2
    - b<>LOOP:
    - DO:
    - ACTION quickbase[5RnE6yP] record create -> c:
    table: '"IT Project and Release Management: Copy of Projects" <bqvp6h3mi>'
    ___: ___
    project_name: '{{b.name.value}}'
    reference_number: '{{b.reference_number.value}}'
    ...

    ------------------------------
    Julian Ammons
    ------------------------------