{"id":7817,"date":"2024-03-30T17:08:15","date_gmt":"2024-03-30T11:38:15","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=7817"},"modified":"2024-03-30T17:08:20","modified_gmt":"2024-03-30T11:38:20","slug":"graphol-use-to-upload-a-file","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/","title":{"rendered":"GraphOL use to Upload A file"},"content":{"rendered":"\n

Introduction:<\/strong><\/p>\n\n\n\n

    In this GraphQL guide, we’ll explore how to upload a file using GraphQL in a TypeScript, MongoDB, and Node.js environment. We’ll set up the schema and resolver to handle file uploads and store the data in a MongoDB database.<\/p>\n\n\n\n

Step 1 :<\/strong> Define the schema for uploading a file<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Step 2<\/strong>: Define the Resolver for uploading a file\u00a0\u00a0\u00a0<\/p>\n\n\n\n

In this code, when a file is uploaded, the data is stored in the MongoDB database. The process involves reading the file using fs.createReadStream to create a readable stream from the CSV file and piping the stream through csvParser() to parse the CSV data. For each row of data parsed from the CSV:<\/p>\n\n\n\n

    \n
  1. It checks if an employee with the same employeID already exists in the database using EmployeModel.findOne.<\/li>\n\n\n\n
  2. If an existing employee is found, it deletes the employee using EmployeModel.findByIdAndDelete.<\/li>\n\n\n\n
  3. It constructs a new employee object with data from the CSV row.<\/li>\n\n\n\n
  4. It creates a new employee record in the database using EmployeModel.create.<\/li>\n\n\n\n
  5. After parsing all rows, it deletes the uploaded CSV file using fs.unlinkSync.<\/li>\n\n\n\n
  6. It resolves the Promise to indicate completion.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n


    Step 3<\/strong>: Uploading a file in Postman<\/p>\n\n\n\n

      \n
    1. Open Postman and create a new request.<\/li>\n\n\n\n
    2. Set the request type to POST.<\/li>\n\n\n\n
    3. Enter the URL of your GraphQL endpoint.<\/li>\n\n\n\n
    4. Switch to the Body tab and select form-data.<\/li>\n\n\n\n
    5. Add a key-value pair where the key is the same as the variable name specified in your GraphQL query (file), and the value is the file you want to upload. Click on the value field of the added key, and select File.<\/li>\n\n\n\n
    6. Click on Select Files and choose the file you want to upload (in this case, file.csv).<\/li>\n\n\n\n
    7. Go to the Headers tab and set the Content-Type header to multipart\/form-data.<\/li>\n\n\n\n
    8. Click Send to execute the request.<\/li>\n<\/ol>\n\n\n\n

      Operation:<\/p>\n\n\n\n

      { “query”: “mutation UploadFile($file: Upload!) { uploadFile(file: $file) { success message } }”,”variables”: { “file”: “file.csv” } }<\/p>\n\n\n\n

      Map:<\/p>\n\n\n\n

      { “0”: [“variables.file”] }<\/p>\n\n\n\n

      0: File<\/p>\n","protected":false},"excerpt":{"rendered":"

      Introduction:     In this GraphQL guide, we’ll explore how to upload a file using GraphQL in a TypeScript, MongoDB, and Node.js environment. We’ll set up the schema and resolver to handle file uploads and store the data in a MongoDB database. Step 1 : Define the schema for uploading a… Continue Reading GraphOL use to Upload A file<\/span><\/i><\/a><\/p>\n","protected":false},"author":507,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-7817","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-uncategorized","7":"h-entry","9":"h-as-article"},"yoast_head":"\nPheonix Solutions - We Empower Your Business Growth<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"Introduction:     In this GraphQL guide, we’ll explore how to upload a file using GraphQL in a TypeScript, MongoDB, and Node.js environment. We’ll set up the schema and resolver to handle file uploads and store the data in a MongoDB database. Step 1 : Define the schema for uploading a… Continue Reading GraphOL use to Upload A file\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-30T11:38:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T11:38:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/03\/schema.png\" \/>\n<meta name=\"author\" content=\"bharat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"bharat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/\"},\"author\":{\"name\":\"bharat\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/5e146ea8682be704a2553a73c97c786b\"},\"headline\":\"GraphOL use to Upload A file\",\"datePublished\":\"2024-03-30T11:38:15+00:00\",\"dateModified\":\"2024-03-30T11:38:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/\"},\"wordCount\":327,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/schema.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/schema.png\",\"datePublished\":\"2024-03-30T11:38:15+00:00\",\"dateModified\":\"2024-03-30T11:38:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#primaryimage\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/schema.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/schema.png\",\"width\":976,\"height\":814},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/graphol-use-to-upload-a-file\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GraphOL use to Upload A file\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/5e146ea8682be704a2553a73c97c786b\",\"name\":\"bharat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d82d0f7350e396f4195f9cbac82c8173f0a2abae54e34fe15122bf92b23dca79?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d82d0f7350e396f4195f9cbac82c8173f0a2abae54e34fe15122bf92b23dca79?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d82d0f7350e396f4195f9cbac82c8173f0a2abae54e34fe15122bf92b23dca79?s=96&r=g\",\"caption\":\"bharat\"},\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/bharat\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"Introduction:     In this GraphQL guide, we’ll explore how to upload a file using GraphQL in a TypeScript, MongoDB, and Node.js environment. We’ll set up the schema and resolver to handle file uploads and store the data in a MongoDB database. Step 1 : Define the schema for uploading a… Continue Reading GraphOL use to Upload A file","og_url":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2024-03-30T11:38:15+00:00","article_modified_time":"2024-03-30T11:38:20+00:00","og_image":[{"url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/03\/schema.png","type":"","width":"","height":""}],"author":"bharat","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"bharat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/"},"author":{"name":"bharat","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/5e146ea8682be704a2553a73c97c786b"},"headline":"GraphOL use to Upload A file","datePublished":"2024-03-30T11:38:15+00:00","dateModified":"2024-03-30T11:38:20+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/"},"wordCount":327,"commentCount":0,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#primaryimage"},"thumbnailUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/03\/schema.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/","url":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#primaryimage"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#primaryimage"},"thumbnailUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/03\/schema.png","datePublished":"2024-03-30T11:38:15+00:00","dateModified":"2024-03-30T11:38:20+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#primaryimage","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/03\/schema.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/03\/schema.png","width":976,"height":814},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/graphol-use-to-upload-a-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"GraphOL use to Upload A file"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/5e146ea8682be704a2553a73c97c786b","name":"bharat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d82d0f7350e396f4195f9cbac82c8173f0a2abae54e34fe15122bf92b23dca79?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d82d0f7350e396f4195f9cbac82c8173f0a2abae54e34fe15122bf92b23dca79?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d82d0f7350e396f4195f9cbac82c8173f0a2abae54e34fe15122bf92b23dca79?s=96&r=g","caption":"bharat"},"url":"https:\/\/pheonixsolutions.com\/blog\/author\/bharat\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-225","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/507"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7817"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7817\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}