GraphQL query Parameters from Azure Synapse Pipeline

GraphQL query Parameters from Azure Synapse Pipeline


0

I am trying to extract and populate data into Azure Synapse Dedicated SQL pool from an API using ADF pipelines. I was able to implement the query without any parameters using the Copy activity, but I have been encountering issues while trying to add parameters. Most of the methods used till now throws the "InValid JSON error".

Below is the sample query. How can I pass a parameter successfully?

query( $createdAt: DateTimeString ){
  Trans( last: 10, filter: { CreatedAt_gte: $createdAt } ) {
    pageInfo {
      hasPreviousPage
      hasNextPage
    }
    edges {
      cursor
      node {
        invNumber
        subledgerId
        CreatedAt
        ModifiedAt
      }
    }
  }
}

3

  • Could you please provide your API details or sample data?

    – Bhavani

    10 hours ago

  • Xledger API with Token based authentication – Used the POST method and request body to query the above sample code

    – Sandeep T

    9 hours ago


  • could you please provide your sample data?

    – Bhavani

    9 hours ago


Load 7 more related questions


Show fewer related questions

0



Leave a Reply

Your email address will not be published. Required fields are marked *