Forum Discussion

JulianAmmons's avatar
JulianAmmons
Qrew Member
4 years ago

JSON in Pipelines

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: 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
------------------------------
No RepliesBe the first to reply