Forum Discussion

vincenr's avatar
vincenr
New Contributor III
3 years ago

String text in JSON output incorrectly using csv parser/formatter to csv

I’ve got the following text in a description field in my raw JSON file, where the double quotes are obviously escaped. How can I change settings in the JSON formatter and/or the CSV parser/formatter...
aleung's avatar
aleung
Contributor III
8 years ago
Copy LinkReport

Keep in mind logging in via login.salesforce.com isn’t exactly the same when logging in via Snaplogic. Since Snaplogic is hitting the Salesforce REST API. Depends on your Salesforce security settings, you might have to pass a security token with your credentials. In case you don’t know your security token.

name > Setup > Personal Setup > My Personal Information > Reset My Security Token.
OR
You can whitelist your cloudplex or groundplex IP to omit the need to pass the security token:

  1. Go to profile detail page.(User can see ‘Login IP Ranges’ related list on Profile detail page.)
  2. Go to Login IP Ranges related list of profile.
  3. Click New button(To Enter the IP Range)
  4. Enter IP Range:

Another possibility is that your profile doesn’t have API enable checked.

An easy way to validate your access is to use a SOQL client like SoqlXplorer (Mac) or ForceExplorer (PC) to test your API access.

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

    [quote=“mohamadelmardini, post:1, topic:391”]
    /GameStop/projects/TargetProject
    would mean you are trying to create a project inside a project. If you just used /GameStop/projects, is a project created?

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

      Have you verified that you have permission to create projects in that org? Also, double check to make sure you have the correct t options set.

      • mohamadelmardin's avatar
        mohamadelmardin
        New Contributor III
        9 years ago
        Copy LinkReport

        To your first question, I am not creating a project within a project because in that path: /GameStop/projects/TargetProject, projects is a project space and already exist. I am trying to create TargetProject inside the already exiting projects space. I have all rights and permissions to create and delete projects in that dev org.

  • psadasivam's avatar
    psadasivam
    New Contributor III
    9 years ago
    Copy LinkReport

    Hi Mohamad,

    I am facing same issue when I try to automate project creation. What was the solution provided by SnapLogic team? Do I need to submit a ticket?

    • sriram's avatar
      sriram
      Former Employee
      9 years ago
      Copy LinkReport

      Attached is a sample pipeline that should be helpful for creating “Projects” using the SnapLogic Metadata snaps.

      SnapLogic Read: Read from an existing project path
      SnapLogic Create: Specify the target project to be created. Example: org/project_space_name/project_name

      SnapLogic Create - Project_2017_05_10.slp (2.9 KB)

      • psadasivam's avatar
        psadasivam
        New Contributor III
        9 years ago
        Copy LinkReport

        @sriram In my case I am trying to create new project on provided org. I am just using SnapLogic create snap not read snap.