Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago
Solved

Read a CSV file from the Right to Left

Good day community. I have a CSV file, see attached, which I would like to pick up the last three fields from the right as their own fields, and the rest of the record/line as a “value” field. sa...
  • SpiroTaleski's avatar
    SpiroTaleski
    2 years ago

    jfpelletier 

    1) You can define the parameters(the ones that are expected to be sent by the system) in the pipeline properties, and access the parameters with "_" and the name of the parameter. ex: _param1. 

    2) You can access all the parameters with the QUERY_STRING argument. 

          ex: _QUERY_STRING

          The result is string containing all the parameters sent by the system. ex: "test=value&test1=value1". 

          So, probably you will need to utilize some of the string functions in order to get/extract the parameters. 

     

     

aleung's avatar
aleung
Contributor III
8 years ago
Copy LinkReport

In Box:
Configuration > OAuth 2.0 Redirect URI = https://elastic.snaplogic.com/api/1/rest/admin/oauth2callback/rest

Integration > Web App Integration > Client Callback URL = https://elastic.snaplogic.com:443/api/1/rest/slsched/feed/Box/Utilities/shared/Box%20Application%20YourDemo%20Task?bearer_token=[your Authorization Token]

In Snaplogic:

OAuth2 Endpoint: Box - Free Online File Storage, Internet File Sharing, Access Documents & Files Anywhere, Backup Data, Share Files
OAuth2 Token: https://www.box.com/api/oauth2/token

Hope this help!

jposey's avatar
jposey
New Contributor II
8 years ago
Copy LinkReport

Thank you for the response. I am new to the concept of the Box Integration and am curious if this is necessary. The error I am receiving is while trying to create/authorize a new REST OAuth2 Account in SnapLogic to use when calling Box APIs via the REST Snaps.

Is your response indicating that I need to create a task for my pipeline in order to get the URL and bearer token for the web integration setup? I would like to be able to create the account and run it locally in SnapLogic prior to moving on to the task creation.

Thanks,
Jason

  • dmiller's avatar
    dmiller
    Former Employee
    4 years ago
    Copy LinkReport

    what do you mean by _p_processing_date

    In SnapLogic terminology:

    • when you reference a field, it is prefaced with the dollar sign ($)
    • when you reference a parameter (which is defined in the pipeline properties), it is prefaced with the underscore (_). Parameters are strings.

    So if the p_processing_date was a parameter, you would use _p_processing_date.
    In this case, you are mapping a date to a field.