RavNeu
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Obtaining response from JSON Post command
I am trying to achieve similar goal. I put the file writer after JSON Formator snap to see the output format. below is the output I am getting: { “response”: { “statusLine”: { “protoVersion”: “HTTP/1.1”, “statusCode”: 200, “reasonPhrase”: “OK” }, “entity”: { “document”: { “id”: “time_to_salesforce”, “rows”: [{ “row”: { “rsId”: “XT_MF_TM_SF_1”, “data”: { “XT_EMPLOYEE_ID”: “A00000”, “XT_ENTERED_HOURS”: 8, “XT_FIRST_NAME”: “XXXXX”, “XT_GLC_ID”: “XXX”, “XT_HOURS_DATE”: “2022-09-30T00:00:00”, “XT_LAST_NAME”: “XXX”, “XT_MODIFIED_BY”: “100000000”, “XT_PAYROLL_EMPLOYEE_ID”: “X000000”, “XT_PAY_TYPE”: “R”, I want to load this into sql server table, so I used mapper after JSON Parser. Below is the expression I used in mapping source side: JSON.parse($response.entity.document.rows[0].row.data.XT_EMPLOYEE_ID) But it says unable to parse JSON value. what expression should i use to pick this field and load into sql table? Also, I got my response as an array rows. So, how will i be able to pick all the rows within the array? thank you for your response in advance!!782Views0likes1CommentRe: SQL Insert from JSON change type and only type
Hi Garrett, were you able to resolve this? I have similar situation. I am trying to pull the pipeline execution history using the Rest API and load it into SQL table. Will you be able to share your sample pipeline that is using rest api to pull the data from the source and load into sql table? I appreciate your help!2KViews0likes0CommentsRe: Return the status of executed Pipelines for the specified time within the Org
Thank you @tlikarish I made the changes as you suggested but I am still getting error: here is the pipeline property i have : Error I am getting: Failure: REST API service endpoint returned error result: status code = 400, Reason: REST API service endpoint returned error result: status code = 400, reason phrase = BAD REQUEST, refer to the error_entity field in the error view document for more details, Resolution: Please check the values of Snap properties. Not sure what I am missing. 🙁3.7KViews0likes3CommentsReturn the status of executed Pipelines for the specified time within the Org
I am new to snaplogic so please bear with me! I am trying to build a pipeline to extract the pipeline execution history for specified time range using GET REST snap. I could see below Query in the documentation: GET https://elastic.snaplogic.com/api/1/rest/public/runtime/orgname?start=&end=> has anyone used this api? how can I pass the value of start and end dates? I don’t want to hard code these dates as i want to make my pipeline more dynamic. I want to pass start date as first day of the previous month and end date as the last date of the previous month. I got above error while I try to create a snap. it says error on the index 87 which is “>” in the api query. So, I removed “>” and only used https://elastic.snaplogic.com/api/1/rest/public/runtime/orgname?start=&end= but still got below error: Failure: REST API service endpoint returned error result: status code = 404, Reason: REST API service endpoint returned error result: status code = 404, reason phrase = NOT FOUND, refer to the error_entity field in the error view document for more details, Resolution: Please check the values of Snap properties. Any help will be appreciated!5.3KViews0likes5Comments