SQL Code | Community
Skip to main content
prabhuk78522504
prabhuk78522504
Level 2
February 23, 2017
Solved

SQL Code

  • February 23, 2017
  • 2 replies
  • 5586 views

Hi,

   I want to directly write a  SQL Query in adobe campaign to pull the data. Is it possible? If possible means please share the document or link to learn me. Please help me

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by vraghav

    Hi Prabhu,

    In addition to the valuable input shared by Florent, an important point to note here is SQL code activity will only allow you to make UPDATEs, INSERTs and DELETEs from an existing table.

    If you wish to fire a SELECT query, you can do so in a JS code activity using functions like sqlGetString(), sqlGetInt(), sqlSelect().

    Please get in touvh with Adobe Support and request for access to JSAPI documentation. Details related to these functions are listed there.

    Support will validate whether your license and then make this documentation available.

    Hope this helps.

    Regards,

    Vipul

    2 replies

    florentlb
    florentlb
    Level 10
    February 23, 2017

    Hi,

    You can use a SQL code activity in a workflow.

    To be able to execute a workflow with an SQL code activity in it, you will need the WORKFLOW and SQL SCRIPT EXECUTION named rights.

    Hope this helps,

    Florent.

      vraghav
      Adobe Employee
      vraghavAdobe EmployeeAccepted solution
      Adobe Employee
      February 23, 2017

      Hi Prabhu,

      In addition to the valuable input shared by Florent, an important point to note here is SQL code activity will only allow you to make UPDATEs, INSERTs and DELETEs from an existing table.

      If you wish to fire a SELECT query, you can do so in a JS code activity using functions like sqlGetString(), sqlGetInt(), sqlSelect().

      Please get in touvh with Adobe Support and request for access to JSAPI documentation. Details related to these functions are listed there.

      Support will validate whether your license and then make this documentation available.

      Hope this helps.

      Regards,

      Vipul

        Terms & ConditionsAccessibility statement

        Loading footer...