Forum Discussion

Sahil's avatar
Sahil
Contributor
4 years ago
Solved

Write expression for conditional check

Hi, I want to write this code in expression snaplogic. I need to map TestID. <xsl:variable name=“TestID”> <xsl:if test=“exists(node()/IDOC/A1[VW=‘F’]/NO)”> <xsl:copy-of select=“node()/IDOC/...
  • jaybodra's avatar
    jaybodra
    7 years ago

    @virender.prajapati I have seen this happening to me in MySQL. I used toLocalDateTimeString() function before inserting it into the DB and worked fine.

    You can try this in your mapper,
    Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0).toLocaleDateTimeString({“format”: “yyyy-MM-dd HH:mm:ss”,“timeZone”:“UTC”})

    You can also look into oracle jdbc url properties

pkona's avatar
pkona
Former Employee
8 years ago

Option 1: If your goal is to ensure that the table is not empty at all times. You can do the following

insert into a temp table. After the insert is successful (add a tail snap to the output view of the insert snap. The tail snap will wait for its input snap to complete before sending the last n documents to its output view)
use execute snap to truncate original table (using execute snap)
use execute snap to insert into original table as select * from temp table (using execute snap)

Option 2: If you are ok with truncating the table just before you start the insert.

use the execute snap to truncate table (enable an output view)
have the rest of the pipeline to read source data and insert into the table

nsmith's avatar
nsmith
New Contributor III
8 years ago

RE: Option 1
Wouldn’t renaming the tables be faster? I.E. Rename table to table_old and table_temp to table? That’s what we do for MySQL.

  • Rudradip's avatar
    Rudradip
    New Contributor II
    7 years ago

    I am also facing the same issue . Is there any way out to call the curl command from the REST snaps ? I checked the documentation but could not find anything regarding that .

    • robin's avatar
      robin
      Former Employee
      7 years ago

      Can you provide an example of the type of curl command(s) you wish to run?

  • Rudradip's avatar
    Rudradip
    New Contributor II
    7 years ago

    This type of sample curl comand : "curl -v http://localhost:8093/query/service
    -d ‘statement=SELECT text FROM tweets WHERE rating = $1 AND when > $2&args=[ 9.5, “1-1-2014”]’ "

  • smudassir's avatar
    smudassir
    Employee
    7 years ago

    First of all, I hope your service http://localhost:8093/query/service is located within the plex/node where you are executing the pipeline. If not, then its an incorrect use-case. If yes, then there are two ways to do it.

    (a) Use REST POST snap. The entire body can be given in Entity property.
    (b) Use Script snap with python/javascript and invoke the post call using the respective library.

    But, first option is the best and the easiest.

  • Sowmya_Rayavara's avatar
    Sowmya_Rayavara
    New Contributor III
    7 years ago

    I have used Rest post snap and it is working for me

  • acesario's avatar
    acesario
    Contributor II
    5 years ago

    Does this mean that your document$ ‘$’ is the curl?

    What if I want to use this?
    curl -f -u “demo:ce544b6ea52a5621fb9d55f8b542d14d” \ -o result.pdf \ -F “url=http://en.wikipedia.org” \ https://api.pdfcrowd.com/convert/20.10/