Forum Discussion

ruchi_pandey's avatar
ruchi_pandey
New Contributor II
6 years ago
Solved

How to use "contains" function in router? I am getting error of expression failure

Hi guys, I am trying to use router with diff data scenarios, where I have to give conditions like: 1) ($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘DI_AVT_DH_PERSON_TYPE_ODS’,‘DI_AVT_DH_PERS...
  • ruchi_pandey's avatar
    ruchi_pandey
    6 years ago

    I solved this issue actually…
    I gave this exp and it worked.

    ($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘PERSON_TYPE_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_CITIZENSHIP_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_LANGUAGE_ODS’) )

    THanks for your quick response though… 🙂

RakeshKumar1's avatar
RakeshKumar1
New Contributor
4 years ago
Copy LinkReport

Hello Team,
Please let me know if this possible ?
With xlsx the file size is becoming big which will block us from sending mail as attachment so want to make it .xlsb.
File is getting corrupted if i am using file extension xlsb.

Thanks!

  • 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.